USER_CONS_COLUMNS view provides information about all columns that are included in constraints in tables that are owned by the current user.
|User name of the constraint’s owner.|
|Name of the schema in which the constraint belongs.|
|The name of the constraint.|
|The name of the table to which the constraint belongs.|
|The name of the column referenced in the constraint.|
|The position of the column within the object definition.|
|The definition of the constraint.|