DBA_CONS_COLUMNS view provides information about all columns that are included in constraints that are specified on all tables in the database.
|User name of the constraint’s owner.|
|Name of the schema in which the constraint belongs.|
|Name of the constraint.|
|Name of the table to which the constraint belongs.|
|Name of the column referenced in the constraint.|
|Position of the column in the object definition.|
|Definition of the constraint.|