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

From Imaginet FAQ
Jump to navigation Jump to search
 
(2 intermediate revisions by one other user not shown)
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
Select the database
+
  Login to http://phpmyadmin.yourdomain.co.za and Select the database
 
[[File:databasedrop_img1.PNG|600px|thumb|center]]
 
[[File:databasedrop_img1.PNG|600px|thumb|center]]
  
Line 10: Line 8:
  
 
* Step 3
 
* Step 3
  You will then be asked if you want to drop the select tables, select "Yes".
+
  You will then be asked if you want to drop the selected tables, select "Yes".
 
[[File:databasedrop_img3.PNG|600px|thumb|center]]
 
[[File:databasedrop_img3.PNG|600px|thumb|center]]
  

Latest revision as of 16:15, 13 December 2021

  • 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 selected 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