The DBA_CONS_COLUMNS view provides the information about all columns that are included in constraints. These constraints are specified on all tables in the database.
|owner||TEXT||The username of the owner to which a constraint belongs.|
|schema_name||TEXT||The name of the schema to which the constraint belongs.|
|constraint_name||TEXT||The name of the constraint.|
|table_name||TEXT||The name of the table to which the constraint belongs.|
|column_name||TEXT||The name of the column referenced in the constraint.|
|position||SMALLINT||The position of the column within the object definition.|
|constraint_def||TEXT||The definition of the constraint.|