Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How do I delete a table from the MySQL Workbench catalog?

Recently I started using MySQL Workbench to design my data structures with an UML diagram. However, there is one thing I could figure out.

It seems that if I delete a table from the EER-diagram view, the table persists in the catalog view (as illustrated by the screenshot below). I could find a way to delete from the catalog view and it still list in the foreign key table reference selection screen.

This is very confusing. How can I effectively remove the table (not only from the view but from the whole project?

workbench

Notice, the two question tables one of which I deleted in the view and redesigned.

like image 861
Friso Kluitenberg Avatar asked Feb 02 '13 10:02

Friso Kluitenberg


People also ask

How do I delete a workbench schema?

First, launch the MySQL workbench and log in to the MySQL Server. Second, right-click the database that you want to remove, for example, testdb2 and choose the Drop Schema... option. Third, MySQL Workbench displays a dialog to confirm the deletion.


1 Answers

In case if the right-click and delete didn't work,

Simply drag and drop the table from the Catalog Tree to the Design area. Then you will see the table gets inserted there. From there, right-click on the table and select delete table. Then the table will get deleted from the whole project (assuming correspondent objects which are needed deleting as well).

Hope this will help someone.

Cheers!

like image 137
Anjana Silva Avatar answered Nov 08 '22 18:11

Anjana Silva