(mysql.info) drop-view
Info Catalog
(mysql.info) create-view
(mysql.info) views
19.3 `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.
The `IF EXISTS' clause prevents an error from occurring for views that
don't exist. When this clause is given, a `NOTE' is generated for each
non-existent view. See show-warnings.
`RESTRICT' and `CASCADE', if given, are parsed and ignored.
This statement was added in MySQL 5.0.1.
Info Catalog
(mysql.info) create-view
(mysql.info) views
automatically generated byinfo2html