Step 1: Login to cPanel
Step 2: Once you’re logged in, locate the "Databases" section of cPanel. Within, there is an icon for "phpMyAdmin". Click on the “phpMyAdmin" icon.
Step 3. In “phpMyAdmin” screen select the database you would like to check and repair using the left menu.
Step 4. You will see a listing of your tables. Click "Check All" or use the check box to select specific tables and then from the drop down labelled “With Selected” choose "Drop Table". “Drop Table” option removes the table/s from the database.
Step 5. This will execute the “DROP TABLE” SQL query to delete all the tables at once. On the next step, confirm you wish to proceed by clicking the Yes button.
Note. You should be very careful while using this command because once a table is deleted then all the information available in that table will also be lost forever.