Object documentationFOREIGNKEYCOLUMNS Locate this document in the navigation structure

 

The system table DOMAIN.FOREIGNKEYCOLUMNS contains the columns of all the referential CONSTRAINT definitions for which the current user has privileges.

Structure

FOREIGNKEYCOLUMNS

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

More Information

Evaluating System Tables, FOREIGNKEYCOLUMNS

SQL Reference Manual, Name of a Referential Constraint (referential_constraint_name)