DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH
 

(mysql.info.gz) DROP VIEW

Info Catalog (mysql.info.gz) DROP TABLE (mysql.info.gz) Data Definition (mysql.info.gz) RENAME TABLE
 
 13.2.11 `DROP VIEW' Syntax
 --------------------------
 
      DROP VIEW [IF EXISTS]
          VIEW_NAME [, VIEW_NAME] ...
          [RESTRICT | CASCADE]
 
 `DROP VIEW' removes one or more views. You must have the `DROP'
 privilege for each view.
 
 You can use the keywords `IF EXISTS' to prevent an error from occurring
 for views that don't exist.  When this clause is given, a `NOTE' is
 generated for each non-existent view.   `SHOW WARNINGS' SHOW
 WARNINGS.
 
 `RESTRICT' and `CASCADE', if given, are parsed and ignored.
 
 This statement was added in MySQL 5.0.1.
 
Info Catalog (mysql.info.gz) DROP TABLE (mysql.info.gz) Data Definition (mysql.info.gz) RENAME TABLE
automatically generated byinfo2html