Specifies that you want SQL to delete all other definitions (constraints, indexes, modules, storage maps, triggers, and views) that refer to the named table and then delete that table definition. This is known as a cascading delete. For stored routines or triggers with a routine or language-semantic dependency, SQL also marks the affected routines and triggers as invalid.