72

DROP Table

In MariaDB, DROP TABLE statement is used to drop a table from a database. It deletes the tables permanently and cannot be recovered.

Syntax:

Example:

Drop the table “Students” created within “tutoraspire” database.

You can verify whether the table is deleted or not.

Output:

You can see that there is no table in database.

Table is now dropped permanently.

---

DROP table using Management Studio

You can drop table using management studio tool. Select the table you want to delete and right click on that. You will see a page like this:

Click on “Drop”. It will generate a pop-up box like this:

Click on ok.

Now the table is deleted. You can verify it by using SHOW statement.

Output:

You can see that table is deleted now.