The ALL_CONS_COLUMNS view provides information about columns included in constraints and accessible to the current user.
| Column name | Data type | Description |
|---|---|---|
OWNER |
VARCHAR2(128) |
The owner of the constraint definition. Always NOT NULL. |
CONSTRAINT_NAME |
VARCHAR2(128) |
The name of the constraint definition. Always NOT NULL. |
TABLE_NAME |
VARCHAR2(128) |
The name of the table with the constraint definition. Always NOT NULL. |
COLUMN_NAME |
VARCHAR2(4000) |
The name of the column or attribute of the object type column specified in the constraint definition. Note: If a constraint is created on a user-defined REF column, the system applies the constraint to the attributes that make up the REF column. As a result, the column names shown in this view are the attribute names, prefixed with the REF column name, in the following format: REF_COLUMN.ATTRIBUTE_NAME. |
POSITION |
NUMBER |
The original position of the column or attribute in the definition of the object. |