Contents Index Referential integrity checking Using Transactions and Isolation Levels

ASA SQL User's Guide
  Ensuring Data Integrity

Integrity rules in the system tables


All the information about database integrity checks and rules is held in the following system tables:

System table Description
SYS.SYSTABLE The view_def column of SYS.SYSTABLE holds CHECK constraints. 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.SYSTRIGGER SYS.SYSTRIGGER holds referential integrity actions.

The referential_action column holds a single character indicating whether the action is cascade (C), delete (D), set null (N), or restrict (R).

The event column holds a single character specifying the event that causes the action to occur: insert, delete (A), insert, update (B), update (C), a delete (D), delete, update (E),insert (I), update (U), insert, delete, update (M).

The trigger_time column shows whether the action occurs after (A) or before (B) the triggering event.

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 more information about the contents of each system table, see System Tables. You can use Sybase Central or Interactive SQL to browse these tables and views.


Contents Index Referential integrity checking Using Transactions and Isolation Levels