FOREIGNKEYS

Definition

The system table FOREIGNKEYS contains all the referential CONSTRAINT definitions for which the current user has privileges.

Structure

FOREIGNKEYS

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

FKEYNAME

CHAR(32)

Name of the referential CONSTRAINT definition

RULE

CHAR(18)

Rules for deleting the table

CREATEDATE

DATE(10)

Creation date of the referential CONSTRAINT definition

CREATETIME

TIME(8)

Creation time of the referential CONSTRAINT definition

COMMENT

LONG

Comment on the referential CONSTRAINT definition

See also:

Evaluating System Tables, FOREIGNKEYS

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