The USER_CONS_COLUMNS view provides the information about all columns that are included in constraints in tables that are owned by the current user.

Parameter Type Description
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 a column referenced in the constraint.
position SMALLINT The position of the column within the object definition.
constraint_def TEXT The definition of the constraint.