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 "Javatpoint" 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.