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_TABLE_USAGE

Information on tables that belong to the current authorization identifier and which are referenced in check or referential constraints. Only the referenced tables are displayed for 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

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 72: CONSTRAINT_TABLE_USAGE view of the INFORMATION_SCHEMA