Drop table Using Management Studio
We can drop table using management studio also.
First create a new table called Books:
CREATE TABLE Books
(
id int,
bookName varchar(255)
);
Step 1: Select the table that we want to delete and then right click on that. We will see a page like this:
Drop Table
Step 2: Click on drop and then it will generate a pop up and click ok.
Drop Table
Step 3: We can verify that the table is deleted or not.
SHOW TABLES;
No Tables 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.
Contact Us