Home Oracle Commands Oracle Data Dictionary
 v$ Performance views

ALL_CONS_OBJ_COLUMNS

List of types an object column or attribute is constrained to in the tables accessible to the user 

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