I read the oracle docs about constraints and I dont quite understand the meaing of the sentence that I put in bold:
CASCADE CONSTRAINTS
Specify CASCADE
CONSTRAINTS
if you want to drop all foreign key constraints that refer to the primary and unique keys defined on the dropped columns as well as all multicolumn constraints defined on the dropped columns. If any constraint is referenced by columns from other tables or remaining columns in the target table, then you must specify CASCADE
CONSTRAINTS
. Otherwise, the statement aborts and an error is returned.
How can a constraint be rerenced by a column? I thought only a column could by referenced by another one when creating a constraint like a foreign key contraint.
Could someone explain me what they mean?