CONNX Data Integration Suite 14.8.0 | Reference Guide | CONNX Catalog Structure | View Description Tables | Constraint_Column_Usage View
 
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