Home Oracle Commands Oracle Data Dictionary
v$ Performance views

DBA_CONS_OBJ_COLUMNS

List of types an object column or attribute is constrained to in all tables in the database 

Columns
   ___________________________
 
   OWNER
      Owner of the table
   TABLE_NAME
      Name of the table containing the object column or attribute
   COLUMN_NAME
      Fully qualified name of the object column or attribute
   CONS_TYPE_OWNER
      Owner of the type that the column is constrained to
   CONS_TYPE_NAME
      Name of the type that the column is constrained to
   CONS_TYPE_ONLY
      Indication of whether the column is constrained to ONLY type

Related:


Simon Sheppard
 SS64.com