Sybase 12.4.2 manual Integrity rules in the system tables, 285

CHAPTER 7 Ensuring Data Integrity

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:

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 “System Tables” in the Adaptive Server IQ Reference Manual. You can use Sybase Central or DBISQL to browse these tables and views.

285