What does Cascade mean

[fatcodeguy]

If I were to perform a DROP TABLE table_name CASCADE command, what would the CASCADE operator do ??
Thanks

 

[ManojP]

Hi,

CASCADE operator is used in Master-Detail relational tables. When you delete a row from the Master table, it automatically deletes all its related rows from the Details table.

Thanks

 

[BJCooperIT]

When dropping a table CASCADE specifies that you also want to delete all other definitions (such as constraints, indexes, triggers, views, etc.) that refer to the named table.

[sup]Everywhere is within walking distance if you have the time. ~Steven Wright[/sup]
Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000
[sup]When posting code, please use TGML to help readability. Thanks![sup]