Difference between revisions of "How to drop all the database tables"

From Imaginet FAQ
Jump to navigation Jump to search
Line 1: Line 1:
If you would like to remove all the existing database tables, you need to use the MySQL drop tables function.
 
 
 
* Step 1
 
* Step 1
 
   Login to http://phpmyadmin.yourdomain.co.za and Select the database
 
   Login to http://phpmyadmin.yourdomain.co.za and Select the database

Revision as of 11:48, 7 November 2012

  • Step 1
 Login to http://phpmyadmin.yourdomain.co.za and Select the database
Databasedrop img1.PNG
  • Step 2
You then need to select all the database tables by selecting "Check All" and then select "Drop Tables" from the drop down option.
Databasedrop img2.PNG
  • Step 3
You will then be asked if you want to drop the select tables, select "Yes".
Databasedrop img3.PNG
  • Step 4
Once all the tables have been removed, you should see the following and notice that there will now be a (0) next to the database.
Databasedrop img4.PNG