Pre-General Availability Draft: 2017-09-22
DROP VIEW [IF EXISTS] view_name [, view_name] ... [RESTRICT | CASCADE]
If any views named in the argument list do not exist, the statement fails with an error indicating by name which nonexisting views it was unable to drop, and no changes are made. Prior to MySQL 8.0.3, the statement returns an error indicating by name which nonexisting views it was unable to drop, but also drops all 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 22.214.171.124, “SHOW WARNINGS Syntax”.
given, are parsed and ignored.