The system table DOMAIN.FOREIGNKEYCOLUMNS contains the columns of all the referential CONSTRAINT definitions for which the current user has privileges.
SCHEMANAME |
CHAR(32) |
Name of the schema of the table |
OWNER |
CHAR(32) |
Name of the owner of the table |
TABLENAME |
CHAR(32) |
Name of the table |
COLUMNNAME |
CHAR(32) |
Name of the column |
FKEYNAME |
CHAR(32) |
Name of the referential CONSTRAINT definition |
REFSCHEMANAME |
CHAR(32) |
Name of the schema of the referenced table |
REFOWNER |
CHAR(32) |
Name of the owner of the referenced table |
REFTABLENAME |
CHAR(32) |
Name of the referenced table |
REFCOLUMNNAME |
CHAR(32) |
Name of the column of the referenced table |
RULE |
CHAR(18) |
Rules for deleting the table |
CREATEDATE |
DATE |
Creation date of the referential CONSTRAINT definition |
CREATETIME |
TIME |
Creation time of the referential CONSTRAINT definition |
COMMENT |
CLOB |
Comment on the referential CONSTRAINT definition |
Evaluating System Tables, FOREIGNKEYCOLUMNS
SQL Reference Manual, Name of a Referential Constraint (referential_constraint_name)