The DBA_CONS_COLUMNS view provides the information about all columns that are included in constraints. These constraints are specified on all tables in the database.

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 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.