Specifies that you want SQL to delete all other view definitions that refer to the named view and then delete that view definition. This is known as a cascading delete. If you delete a view referenced by a stored routine or trigger with a routine or language-semantic dependency, SQL also marks the affected routines and triggers as invalid.