The ALL_CONS_COLUMNS view provides the information about the columns specified in constraints placed on tables accessible by the current user.

Parameter Type Description
owner TEXT The username of the owner to which the 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.