The ALL_CONS_COLUMNS view provides the information about the columns specified in constraints placed on tables accessible by the current user.
| Parameter | Type | Description |
|---|---|---|
| owner | TEXT | The username of the owner to which the constraint belongs. |
| schema_name | TEXT | The name of the schema to which the constraint belongs. |
| constraint_name | TEXT | The name of the constraint. |
| table_name | TEXT | The name of the table to which the constraint belongs. |
| column_name | TEXT | The name of the column referenced in the constraint. |
| position | SMALLINT | The position of the column within the object definition. |
| constraint_def | TEXT | The definition of the constraint. |