Purpose
The USER_CONS_COLUMNS view displays columns that are specified in the constraints on all tables owned by the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
ALL_CONS_COLUMNSDBA_CONS_COLUMNS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| OWNER | VARCHAR2(128) | VARCHAR2(128) | The owner of the column. |
| 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) | YES | The column name in the constraint. |
| POSITION | NUMBER | YES | The position of the column in the constraint. |