DROP VIEW [IF EXISTS]
view_name] ... [RESTRICT | CASCADE]
VIEW removes one or more views. You must have the
DROP privilege for each view. If any of the views named in the argument list do
not exist, MySQL returns an error indicating by name which nonexisting views it was unable to drop, but it also
drops all of the views in the list that do exist.
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 nonexistent view. See Section
SHOW WARNINGS Syntax".
CASCADE, if given, are parsed and ignored.