Note
This view is available starting with V2.2.30.
Purpose
This view displays the column information of all constraints of tables owned by the current user.
Applicability
This view is available only in Oracle-compatible mode.
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 to which the constraint belongs. |
| COLUMN_NAME | VARCHAR2(4000) | YES | The name of the column in the constraint. |
| POSITION | NUMBER | YES | The position of the column in the constraint. |
Sample query
Query the column information of constraints in the TBL3 table owned by the current user.
obclient [SYS]> SELECT * FROM SYS.USER_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 accessible to the current user: ALL_CONS_COLUMNS
Query the constraint information of all tables in the current tenant: DBA_CONS_COLUMNS
For more information about constraints, see Define the constraint type for a column.