Constraint_Column_Usage View

Identifies the columns that are referenced by referential constraints.

This view is part of the ANSI SQL-2 standard Information Schema.

 

Column

Data Type

N

Description

RECORD_NUMBER

integer

n

unique identifier for this record of metadata

TABLE_CATALOG

identifier

n

table catalog

TABLE_SCHEMA

identifier

n

table schema

TABLE_NAME

identifier

n

table name

COLUMN_NAME

identifier

n

column name

CONSTRAINT_CATALOG

identifier

n

constraint catalog

CONSTRAINT_SCHEMA

identifier

n

constraint schema

CONSTRAINT_NAME

identifier

n

constraint name