Difference between revisions of "How to drop all the database tables"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
* Step 1 | * Step 1 | ||
Select the database | Select the database | ||
| − | [[File:databasedrop_img1.PNG|thumb|center]] | + | [[File:databasedrop_img1.PNG|600px|thumb|center]] |
* Step 2 | * 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. | 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_img2.PNG|thumb|center]] | + | [[File:databasedrop_img2.PNG|600px|thumb|center]] |
* 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 select tables, select "Yes". | ||
| − | [[File:databasedrop_img3.PNG|thumb|center]] | + | [[File:databasedrop_img3.PNG|600px|thumb|center]] |
* Step 4 | * 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. | 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_img4.PNG|thumb|center]] | + | [[File:databasedrop_img4.PNG|600px|thumb|center]] |
Revision as of 08:40, 5 November 2012
If you would like to remove all the existing database tables, you need to use the MySQL drop tables function.
- Step 1
Select the database
- 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.
- Step 3
You will then be asked if you want to drop the select tables, select "Yes".
- 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.
