Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Meaning of cascade constraint

terrencecahillAug 5 2019 — edited Aug 11 2019

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?

This post has been answered by Frank Kulash on Aug 5 2019
Jump to Answer
Comments
Post Details
Added on Aug 5 2019
8 comments
17,155 views