Difference between revisions of "How to drop all the database tables"
Jump to navigation
Jump to search
(Created page with "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 [[File:databasedrop_img1.PNG|thumb|c...") |
|||
| Line 1: | Line 1: | ||
If you would like to remove all the existing database tables, you need to use the MySQL drop tables function. | 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 | Select the database | ||
[[File:databasedrop_img1.PNG|thumb|center]] | [[File:databasedrop_img1.PNG|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|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|thumb|center]] | ||
| − | Step 4 | + | * Step 4 |
| − | Once all the tables have been removed, you should see the following. | + | 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|thumb|center]] | ||
Revision as of 15:12, 2 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.
