DROP TABLE
To drop a table permanently (with no option for the recovery of the table) from a MariaDB database, the MariaDB DROP TABLE statement is used.
Syntax:
DROP TABLE table_name;
Example:
DROP TABLE players; |
Explanation:
The “players” is an already existing table. The selected table will be deleted permanently from the database after the execution of the above code. To verify the successful dropping of the table, check for all the remaining Tables in the database, using the command:
SHOW tables;
Drop table using Management Studio:
To drop a table using management studio tool, select the table to delete and right-click on that.
- Click on “Drop” from the dropdown menu.
- Click on “OK” from the generated pop-up box.
The selected table will be deleted permanently from the database. Verify the successful dropping of the table, using the command:
SHOW tables;