DBA_CONS_COLUMNS v16
The DBA_CONS_COLUMNS view provides information about all columns that are included in constraints that are specified on all tables in the database.
| Name | Type | Description |
|---|---|---|
owner | TEXT | User name of the constraint’s owner. |
schema_name | TEXT | Name of the schema in which the constraint belongs. |
constraint_name | TEXT | Name of the constraint. |
table_name | TEXT | Name of the table to which the constraint belongs. |
column_name | TEXT | Name of the column referenced in the constraint. |
position | SMALLINT | Position of the column in the object definition. |
constraint_def | TEXT | Definition of the constraint. |