All the information about integrity checks and rules in a database is held in the following system 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. |
For a description of the contents of each system table, see Chapter 9, “System Tables” in the Reference: Building Blocks, Tables, and Procedures. You can use Sybase Central or dbisql to browse these tables and views.
