Loading...
Select Version
Information on columns that belong to the current authorization identifier and which are used in integrity constraints (except columns that are referenced in referential constraints).
Column name |
Data type |
Contents |
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 |
COLUMN_NAME |
CHAR (31) |
Column name |
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 71: CONSTRAINT_COLUMN_USAGE view of the INFORMATION_SCHEMA