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.
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.