Drop Multiple Table
Let’s look at an example where we want to drop more than one table using the DROP TABLE statement.
Query:
DROP TABLE Products, States;
Output:
Explnation: As we can see in the output that now no table named as product and states in database.
Drop Table in MariaDB
MariaDB is one of the most widely used open-source relational database management systems, it offers many useful commands for manipulating database structures. It supports the same features that MySQL does but with additional features. Some of the most significant features are new storage engines, JSON API support, and parallel data replication.
One such command that performs an important role in database administration is the DROP TABLE command. In this article, We will discuss the DROP TABLE command in MariaDB along with syntax, table creation, and examples of dropping the table using multiple methods.