The constraint_column_usage view provides information about columns used by constraints.
| Column name | Data type | Description |
|---|---|---|
table_catalog |
sql_identifier |
The name of the current database holding the column that is used by some constraint. |
table_schema |
sql_identifier |
The name of the schema holding the column that is used by some constraint. |
table_name |
sql_identifier |
The name of the table holding the column that is used by some constraint. |
column_name |
sql_identifier |
The name of the column used by some constraint. |
constraint_catalog |
sql_identifier |
The name of the database that contains the constraint. |
constraint_schema |
sql_identifier |
The name of the schema that contains the constraint. |
constraint_name |
sql_identifier |
The name of the constraint. |