--

MariaDB starting with 10.6.1
----------------------------
MariaDB 10.6.1 supports Atomic DDL and DROP VIEW for a singular view is
atomic. Dropping multiple views is crash-safe.

Examples
--------

DROP VIEW v,v2;

Given views v and v2, but no view v3

DROP VIEW v,v2,v3;
ERROR 1051 (42S02): Unknown table 'v3'

DROP VIEW IF EXISTS v,v2,v3;
Query OK, 0 rows affected, 1 warning (0.01 sec)

SHOW WARNINGS;
+-------+------+-------------------------+
| Level | Code | Message                 |
+-------+------+-------------------------+
| Note  | 1051 | Unknown table 'test.v3' |
+-------+------+-------------------------+

URL: https://mariadb.com/kb/en/drop-view/https://mariadb.com/kb/en/drop-view/