2.89 ALL_CONS_OBJ_COLUMNS
ALL_CONS_OBJ_COLUMNS
displays information about the types that object columns (or attributes) or collection elements have been constrained to, in the tables accessible to the current user.
Related Views
-
DBA_CONS_OBJ_COLUMNS
displays information about the types that object columns (or attributes) or collection elements have been constrained to, in all tables in the database. -
USER_CONS_OBJ_COLUMNS
displays information about the types that object columns (or attributes) or collection elements have been constrained to, in the tables owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the table |
|
|
|
Name of the table containing the object column or attribute |
|
|
|
Fully qualified name of the object column or attribute |
|
|
|
Owner of the type that the column (or element) is constrained to |
|
|
|
Name of the type that the column (or element) is constrained to |
|
|
|
Indicates whether the column (or element) is constrained to |
See Also: