DROP TABLE with MariaDB Xpand

Overview

MariaDB Xpand supports the DROP TABLE statement to drop tables.

Compatibility

  • MariaDB Xpand 5.3

  • MariaDB Xpand 6.0

  • MariaDB Xpand 6.1

DROP TABLE

To drop a table with MariaDB Xpand, use the DROP TABLE statement:

DROP TABLE hq_sales.invoices;

Special Cases

  • Xpand does not wait for concurrent transactions to be committed before dropping a table

  • Xpand does not support the % wildcard in database names