Purpose
The DBA_CONS_COLUMNS view displays the columns that are specified in the constraints on all tables in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
USER_CONS_COLUMNS
ALL_CONS_COLUMNS
Columns
| Column | 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. |