Note
This view is available starting with V2.2.30.
Purpose
This view displays the column information of constraints on all tables.
Applicability
This view applies only to OceanBase Database in Oracle mode.
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 to which the constraint belongs. |
| COLUMN_NAME | VARCHAR2(4000) | NO | The name of the column in the constraint. |
| POSITION | NUMBER | NO | The position of the column in the constraint. |
Sample query
Query the column information of constraints on the TBL3 table.
obclient [SYS]> SELECT * FROM SYS.DBA_CONS_COLUMNS WHERE TABLE_NAME='TBL3';
The query result is as follows:
+-------+----------------------------+------------+-------------+----------+
| OWNER | CONSTRAINT_NAME | TABLE_NAME | COLUMN_NAME | POSITION |
+-------+----------------------------+------------+-------------+----------+
| SYS | TBL3_OBPK_1744012420113641 | TBL3 | COL1 | 1 |
+-------+----------------------------+------------+-------------+----------+
1 row in set
References
Query the constraint information of all tables owned by the current user: USER_CONS_COLUMNS
Query the constraint information of all tables accessible to the current user: ALL_CONS_COLUMNS
For more information about constraints, see Define the constraint type for a column.