SYSCSTDEP
The SYSCSTDEP view records the tables on which constraints are defined.
The following table describes the columns in the SYSCSTDEP view:
| Column Name | System Column Name | Data Type | Description |
|---|---|---|---|
| TABLE_SCHEMA | TDBNAME | VARCHAR(128) | Name of the SQL schema that contains the table on which the constraint is dependent |
| TABLE_NAME | TBNAME | VARCHAR(128) | Name of the table on which the constraint is dependent. This is the SQL table name if it exists otherwise it is the system table name. |
| CONSTRAINT_SCHEMA | CDBNAME | VARCHAR(128) | Name of the schema of the constraint. |
| CONSTRAINT_NAME | RELNAME | VARCHAR(128) | Name of the constraint. |
| SYSTEM_TABLE_NAME | SYS_TNAME | CHAR(10) | System name of the table. |
| SYSTEM_TABLE_SCHEMA | SYS_DNAME | CHAR(10) | System name of the schema containing the table. |
| IASP_NUMBER | IASPNUMBER | SMALLINT | Specifies the independent auxiliary storage pool (IASP) number. |
| SYSTEM_CONSTRAINT_SCHEMA | SYS_CDNAME | CHAR(10) | Name of the system schema containing the constraint. |