Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 305 / 536

CHAPTER 7 Ensuring Data Integrity
285
Integrity rules in the system tables
All the information about integrity checks and rules in a database is held in the
following system tables and views:
For a description of the contents of each system table, see “System Tables” in
the Adaptive Server IQ Reference Manual. You can use Sybase Central or
DBISQL to browse these tables and views.
System table Description
SYS.SYSTABLE
CHECK constraints are held in the
view_def
column of SYS.SYSTABLE. For views, the
view_def
holds the CREATE VIEW command
that created the view. You can check whether a
particular table is a base table or a view by
looking at the
table_type column, which is
BASE or VIEW.
SYS.SYSFOREIGNKEYS
This view presents the foreign key information
from the two tables SYS.SYSFOREIGNKEY
and SYS.SYSFKCOL in a more readable
format.
SYS.SYSCOLUMNS
This view presents the information from the
SYS.SYSCOLUMN table in a more readable
format. It includes default settings and primary
key information for columns.