(mysql.info) drop-view

情報カタログ

(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.
 

情報カタログ

(mysql.info) create-view

(mysql.info) views