Drop One Table
Let’s look at a simple DROP TABLE example that shows how to use the DROP TABLE statement to drop one table in MariaDB.
Query:
DROP TABLE employees;
Check using SHOW TBALES command.
Output:
Explanation: : As we can see in the output that now no table named as employees is there 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.