DROP VIEW [schema .] view [CASCADE CONSTRAINTS];