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

Latest revision as of 16:15, 13 December 2021

 Login to http://phpmyadmin.yourdomain.co.za and Select the database

You then need to select all the database tables by selecting "Check All" and then select "Drop Tables" from the drop down option.

You will then be asked if you want to drop the selected tables, select "Yes".

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.

@@ 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
+  Login to http://phpmyadmin.yourdomain.co.za and Select the database
+[[File:databasedrop_img1.PNG|600px|thumb|center]]
-Step 1
+* Step 2
-  Select the database
+  You then need to select all the database tables by selecting "Check All" and then select "Drop Tables" from the drop down option.
-[[File:databasedrop_img1.PNG|thumb|center]]
+[[File:databasedrop_img2.PNG|600px|thumb|center]]
-Step 2
+* Step 3
-You then need to select all the database tables by selecting "Check All" and then select "Drop Tables" from the drop down option.
+ You will then be asked if you want to drop the selected tables, select "Yes".
-[[File:databasedrop_img2.PNG|thumb|center]]
+[[File:databasedrop_img3.PNG|600px|thumb|center]]
-Step 3
+* Step 4
-You will then be asked if you want to drop the select tables, select "Yes".
+ 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.
-[[File:databasedrop_img3.PNG|thumb|center]]
+[[File:databasedrop_img4.PNG|600px|thumb|center]]
-Step 4
-Once all the tables have been removed, you should see the following.
-[[File:databasedrop_img4.PNG|thumb|center]]