Drop tables in MySQL

You can use the drop table command to remove a table definition and all data, indexes, triggers, constraints, and permission specifications for that table.

IMPORTANT: You should be very careful with this command because after you delete a table, you can’t retrieve any of that information.

You can drop tables within MySQL® and MariaDB® by following these steps:

1. Login to MySQL or MariaDB:

    root@localhost# mysql -u root -p
    Enter password:*******
   

2. Change to the database and drop the table:

    mysql> use TESTINGDB;
    Database changed
    mysql> DROP TABLE testing_tbl;
    Query OK, 0 rows affected (0.8 sec)
    mysql>