Purpose
The ALL_CONS_COLUMNS view describes columns that are accessible to the current user and that are specified in constraints.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
USER_CONS_COLUMNSDBA_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. |