CONSTRAINTCOLUMNS 
Definition
The system table CONSTRAINTCOLUMNS contains the columns specified in the CONSTRAINT definitions for the tables for which the current user has privileges.
Structure
CONSTRAINTCOLUMNS
SCHEMANAME |
CHAR(32) |
Name of the schema |
OWNER |
CHAR(32) |
Name of the owner |
TABLENAME |
CHAR(32) |
Name of table with the CONSTRAINT definition |
CONSTRAINTNAME |
CHAR(32) |
Name of the CONSTRAINT definition |
CONSTRAINTTYPE |
CHAR(12) |
Type of CONSTRAINT definition (CHECK | FOREIGN KEY | KEY | UNIQUE_CONST) |
COLUMNNAME |
CHAR(32) |
Name of the column |
COLUMNNO |
FIXED(4) |
Number of the column within the table or constraint |
See also:
SQL Reference Manual, CONSTRAINT Definition (constraint_definition)