In MariaDB, DROP TABLE statement is used to drop a table from a database. It deletes the tables permanently and cannot be recovered.
DROP TABLE table_name ;
Drop the table "Students" created within "Javatpoint" database.
DROP TABLE Students;
You can verify whether the table is deleted or not.
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.
You can see that table is deleted now.