ALL_CONS_COLUMNS view provides information about the columns specified in constraints placed on tables accessible by the current user.
|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.|