login

Subscribe to SQL Tutorial website RSS Feed
 » SQL Data Definition » SQL DROP VIEW Statement

SQL DROP VIEW Statement

SQL DROP VIEW statement removes view definition from the system catalog and the dependent objects of that view will become invalid.Here are some syntaxes of DROP VIEW statement in some common RDBMSs:

DROP VIEW in Oracle

DROP VIEW view_name [CASCADE CONSTRAINTS];

DROP VIEW in MS SQL server

you can drop multiple views usinh DROP VIEW statement, each view's name is seperated by a comma.

DROP VIEW {view_name} [,...]

DROP VIEW in MySQL

DROP VIEW [IF EXISTS]  view_name [,...]  
[RESTRICT | CASCADE]
Read On