I have made a database in MySql Workbench. Along the design, I deleted a couple of tables since they weren't necessary. But, when I try to export the database to phpmyadmin, all of those tables appear in the code. How do I solve this?
4
-
Have you commited your tables deletion?AlexZam– AlexZam2012-10-22 16:40:05 +00:00Commented Oct 22, 2012 at 16:40
-
No, i'm new to mysql workbench. how do i do that?Bora Bogdan– Bora Bogdan2012-10-22 16:41:33 +00:00Commented Oct 22, 2012 at 16:41
-
Can you elaborate on what did you do to "make" the database?Sergio– Sergio2012-10-24 01:20:36 +00:00Commented Oct 24, 2012 at 1:20
-
Using MySql Workbench i added tables, making the links between them: one to one, one to many, many to many.Then some new rules appeared and a few tables weren't needed. So i right clicked on them and deleted them. But when i tried to export the database in sql format, those tables still appeared, meaning they weren't completely deleted.Bora Bogdan– Bora Bogdan2012-10-24 12:49:05 +00:00Commented Oct 24, 2012 at 12:49
Add a comment
|
1 Answer
In MySQL Workbench 6.0 CE.
I think it is very easy.
Suppose first you add a table in the database. for doing that.
- Click on Database Menu. and then click on "Next to Database".
- You all database will show on left side.
- Click on db and then right click on table. Create New Table.
- Now you will create a new table. Click on Apply and you watch table is created.
Now You need to drop this table.
Just right click on a table. and click on drop table. and a dialog box will open. Choose drop and the your created table will be deleted.
Now if you export your db, this deleted table will not show up.
If you had made relationships among different tables then the table will not be deleted until you remove that relationship.
Thanks.
answered Nov 6, 2013 at 8:09
Muhammad Rizwan Kaim Khani
2,1003 gold badges30 silver badges38 bronze badges