Your Browser is not longer supported

Please use Google Chrome, Mozilla Firefox or Microsoft Edge to view the page correctly
Loading...

{{viewport.spaceProperty.prod}}

CONSTRAINT_COLUMN_USAGE

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
belongs

TABLE_NAME

CHAR (31)

Name of the table referenced in the
integrity constraint

COLUMN_NAME

CHAR (31)

Column name

CONSTRAINT_CATALOG

CHAR (18)

Database name

CONSTRAINT_SCHEMA

CHAR (31)

Name of the schema to which the table
with the integrity constraint belongs

CONSTRAINT_NAME

CHAR (31)

Name of the integrity constraint

Table 71: CONSTRAINT_COLUMN_USAGE view of the INFORMATION_SCHEMA