Overview
DBA_CONS_COLUMNS describes columns that are specified in constraints on all tables in the database.
Related views
USER_CONS_COLUMNS
ALL_CONS_COLUMNS
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | NO | The owner of the constraint. |
| CONSTRAINT_NAME | VARCHAR2(128) | NO | The name of the constraint. |
| TABLE_NAME | VARCHAR2(128) | NO | The name of the table containing the constraint. |
| COLUMN_NAME | VARCHAR2(4000) | NO | The column name in the constraint. |
| POSITION | NUMBER | NO | The position of the column in the constraint. |
