ALL_CONS_COLUMNS

Purpose

This view displays the column information in constraints of all tables that are accessible to the current user.

Columns

Sample query

Query the column information in constraints of all tables that are accessible to the current user in the TBL3 table.

obclient [SYS]> SELECT * FROM SYS.ALL_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 that are owned by the current user: USER_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.