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