Note
This view is available starting with V2.2.30.
Purpose
This view displays the column information of all constraints in all tables.
Applicability
This view is available only in Oracle-compatible mode of OceanBase Database.
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 the constraints in 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.