System Catalog Tables Definitions

Table D–1 lists all the tables in the system catalog. It gives a brief description of their purpose and lists the column definitions for every table.

**Table D–1.** System Catalog Table Definitions
Table	Purpose	Column	Data Type	Size
`sys_chk_constrs`	Contains the CHECK clause for each check constraint specified on a user table.	`chkclause`	`varchar`	`2000`
		`chkseq`	`integer`	`4`
		`cnstrname`	`varchar`	`32`
		`owner`	`varchar`	`32`
		`tblname`	`varchar`	`32`
`sys_chkcol_usage`	Contains one entry for each column on which the check constraint is specified	`cnstrname`	`varchar`	`32`
		`colname`	`varchar`	`32`
		`owner`	`varchar`	`32`
		`tblname`	`varchar`	`32`
`sys_keycol_usage`	Contains one entry for each column on which primary or foreign key is specified	`cnstrname`	`varchar`	`32`
		`colname`	`varchar`	`32`
		`colposition`	`integer`	`4`
		`owner`	`varchar`	`32`
		`tblname`	`varchar`	`32`
`sys_ref_constrs`	Contains one entry for each referential constraint specified on a user table	`cnstrname`	`varchar`	`32`
		`deleterule`	`varchar`	`1`
		`owner`	`varchar`	`32`
		`refcnstrname`	`varchar`	`32`
		`refowner`	`varchar`	`32`
		`reftblname`	`varchar`	`32`
		`tblname`	`varchar`	`32`
`sys_tbl_constrs`	Contains one entry for each table constraint.	`cnstrname`	`varchar`	`32`
		`cnstrtype`	`varchar`	`1`
		`idxname`	`varchar`	`32`
		`owner`	`varchar`	`32`
		`tblname`	`varchar`	`32`
`syscalctable`	Contains exactly one row with a single column with a value of 100.	`fld`	`integer`	`4`
`syscolauth`	Contains the update privileges held by users on individual columns of tables in the database.	`col`	`varchar`	`32`
		`grantee`	`varchar`	`32`
		`grantor`	`varchar`	`32`
		`ref`	`varchar`	`1`
		`tbl`	`varchar`	`32`
		`tblowner`	`varchar`	`32`
		`upd`	`varchar`	`1`
`syscolumns`	Contains one row for each column of every table in the database.	`charset`	`varchar`	`32`
		`col`	`varchar`	`32`
		`collation`	`varchar`	`32`
		`coltype`	`varchar`	`10`
		`dflt_value`	`varchar`	`250`
		`id`	`integer`	`4`
		`nullflag`	`varchar`	`1`
		`owner`	`varchar`	`32`
		`scale`	`integer`	`4`
		`tbl`	`varchar`	`32`
		`width`	`integer`	`4`
`sysdatatypes`	Contains information on each data type supported by the database.	`autoincr`	`smallint`	`2`
		`casesensitive`	`smallint`	`2`
		`createparams`	`varchar`	`32`
		`datatype`	`smallint`	`2`
		`dhtypename`	`varchar`	`32`
		`literalprefix`	`varchar`	`1`
		`literalsuffix`	`varchar`	`1`
		`localtypename`	`varchar`	`1`
		`nullable`	`smallint`	`2`
		`odbcmoney`	`smallint`	`2`
		`searchable`	`smallint`	`2`
		`typeprecision`	`integer`	`4`
		`unsignedattr`	`smallint`	`2`
`sysdbauth`	Contains the database-wide privileges held by users.	`dba_acc`	`varchar`	`1`
		`grantee`	`varchar`	`32`
		`res_acc`	`varchar`	`1`
`sysidxstat`	Contains statistics for each index in the database.	`idxid`	`integer`	`4`
		`nleaf`	`integer`	`4`
		`nlevels`	`smallint`	`2`
		`recsz`	`integer`	`4`
		`rssid`	`integer`	`4`
		`tblid`	`integer`	`4`
`sysindexes`	Contains one row for each component of an index in the database. For an index with n components, there will be n rows in this table.	`colname`	`varchar`	`32`
		`id`	`integer`	`4`
		`idxcompress`	`varchar`	`1`
		`idxmethod`	`varchar`	`1`
		`idxname`	`varchar`	`32`
		`idxorder`	`varchar`	`1`
		`idxowner`	`varchar`	`32`
		`idxsegid`	`integer`	`4`
		`idxseq`	`integer`	`4`
		`idxtype`	`varchar`	`1`
		`rssid`	`integer`	`4`
		`tbl`	`varchar`	`32`
		`tblowner`	`varchar`	`32`
`syssynonyms`	Contains one entry for each synonym in the database.	`ispublic`	`smallint`	`2`
		`screator`	`varchar`	`32`
		`sname`	`varchar`	`32`
		`sowner`	`varchar`	`32`
		`sremdb`	`varchar`	`32`
		`stbl`	`varchar`	`32`
		`stblowner`	`varchar`	`32`
`systabauth`	Contains privileges held by users for tables, views, and procedures.	`alt`	`varchar`	`1`
		`del`	`varchar`	`1`
		`exe`	`character`	`1`
		`grantee`	`varchar`	`32`
		`grantor`	`varchar`	`32`
		`ins`	`varchar`	`1`
		`ndx`	`varchar`	`1`
		`ref`	`varchar`	`1`
		`sel`	`varchar`	`1`
		`tbl`	`varchar`	`32`
		`tblowner`	`varchar`	`32`
		`upd`	`varchar`	`1`
`systables`	Contains one row for each table in the database.	`creator`	`varchar`	`32`
		`has_ccnstrs`	`varchar`	`1`
		`has_fcnstrs`	`varchar`	`1`
		`has_pcnstrs`	`varchar`	`1`
		`has_ucnstrs`	`varchar`	`1`
		`id`	`integer`	`4`
		`owner`	`varchar`	`32`
		`rssid`	`integer`	`4`
		`segid`	`integer`	`4`
		`tbl`	`varchar`	`32`
		`tbl_status`	`varchar`	`1`
		`tblpctfree`	`integer`	`4`
		`tbltype`	`varchar`	`1`
`systblspaces`	No longer used.	`id`	`integer`	`4`
		`tsname`	`varchar`	`32`
`systblstat`	Contains table statistics for each user table.	`card`	`integer`	`4`
		`npages`	`integer`	`4`
		`pagesz`	`integer`	`4`
		`recsz`	`integer`	`4`
		`rssid`	`integer`	`4`
		`tblid`	`integer`	`4`
`sysviews`	Contains information on each view in the database.	`creator`	`varchar`	`32`
		`owner`	`varchar`	`32`
		`seq`	`integer`	`4`
		`viewname`	`varchar`	`32`
		`viewtext`	`varchar`	`2000`