Note
This view is available starting with V2.2.30.
Purpose
This view displays the columns in the constraints of 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 in which the constraint is located. |
| 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 columns in the constraints of 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
USER_CONS_COLUMNS: view all constraints of tables owned by the current user.
ALL_CONS_COLUMNS: view all constraints of tables accessible to the current user.
For more information about constraints, see Define the constraint type for a column.