Information on referential constraints belonging to the current authorization identifier, as well as the name of the referenced UNIQUE or primary key constraint.
Column name |
Data type |
Contents |
CONSTRAINT_CATALOG |
CHAR (18) |
Database name |
CONSTRAINT_SCHEMA |
CHAR (31) |
Name of the schema to which the table |
CONSTRAINT_NAME |
CHAR (31) |
Name of the referential constraint |
UNIQUE_CONSTRAINT |
CHAR (18) |
Database name |
UNIQUE_CONSTRAINT |
CHAR (31) |
Name of the schema of the referenced |
UNIQUE_CONSTRAINT |
CHAR (31) |
Name of the UNIQUE or primary key |
MATCH_OPTION |
CHAR (7) |
NONE |
UPDATE_RULE |
CHAR (11) |
NO ACTION |
DELETE_RULE |
CHAR (11) |
NO ACTION |
Table 82: REFERENTIAL_CONSTRAINTS view of the INFORMATION_SCHEMA