SYSKEYCST
The SYSKEYCST view contains one or more rows for each UNIQUE KEY, PRIMARY KEY, or FOREIGN KEY in the SQL schema. There is one row for each column in every unique or primary key constraint and the referencing columns of a referential constraint.
The following table describes the columns in the SYSKEYCST view:
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
CONSTRAINT_SCHEMA | CDBNAME | VARCHAR(128) | Name of the schema containing the constraint. |
CONSTRAINT_NAME | RELNAME | VARCHAR(128) | Name of the constraint. |
TABLE_SCHEMA | TDBNAME | VARCHAR(128) | Name of the schema containing the table. |
TABLE_NAME | TBNAME | VARCHAR(128) | Name of the table. |
COLUMN_NAME | COLNAME | VARCHAR(128) | Name of the column. |
ORDINAL_POSITION | COLSEQ | INTEGER | The position of the column within the key |
COLUMN_POSITION | COLNO | INTEGER | The position of the column within the row |
TABLE_OWNER | CREATOR | VARCHAR(128) | Owner of the table. |
SYSTEM_COLUMN_NAME | SYS_CNAME | CHAR(10) | System name of the column. |
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 schema table. |
SYSTEM_CONSTRAINT_SCHEMA | SYS_CDNAME | CHAR(10) | Name of the system schema containing the constraint. |