FOREIGNKEYCOLUMNS
The system table DOMAIN.FOREIGNKEYCOLUMNS
contains
the columns of all the referential CONSTRAINT
definitions
for which the current user has privileges.
Structure
|
CHAR(32) |
Name of the schema of the table |
|
CHAR(32) |
Name of the owner of the table |
|
CHAR(32) |
Name of the table |
|
CHAR(32) |
Name of the column |
|
CHAR(32) |
Name of the referential CONSTRAINT definition |
|
CHAR(32) |
Name of the schema of the referenced table |
|
CHAR(32) |
Name of the owner of the referenced table |
|
CHAR(32) |
Name of the referenced table |
|
CHAR(32) |
Name of the column of the referenced table |
|
CHAR(18) |
Rules for deleting the table |
|
DATE |
Creation date of the referential CONSTRAINT definition |
|
TIME |
Creation time of the referential CONSTRAINT definition |
|
CLOB |
Comment on the referential CONSTRAINT definition |
More Information
Evaluating System Tables
, FOREIGNKEYCOLUMNS
SQL Reference Manual
, Name
of a Referential Constraint (referential_constraint_name)