Information on integrity constraints on the database schemas that belong to the current authorization identifier.
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 integrity constraint |
TABLE_CATALOG |
CHAR (18) |
Database name |
TABLE_SCHEMA |
CHAR (31) |
Name of the schema to which the table |
TABLE_NAME |
CHAR (31) |
Name of the table referenced in the |
CONSTRAINT_TYPE |
VARCHAR (11) |
Type of integrity constraint: |
IS_DEFERRABLE |
CHAR (3) |
NO |
INITIALLY_DEFERRED |
CHAR (3) |
NO |
Table 98: TABLE_CONSTRAINTS view of the INFORMATION_SCHEMA