Bug #48055 Can't delete schema
Submitted: 14 Oct 2009 20:15 Modified: 20 Apr 2010 15:16
Reporter: Dimitriy A Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S2 (Serious)
Version:5.1.18 OSS OS:Windows (XP Pro)
Assigned to: Mike Lischke CPU Architecture:Any
Tags: delete, schema

[14 Oct 2009 20:15] Dimitriy A 
Description:
Can't delete any schemas in MySQL Model tab under Physical Schemata section.

How to repeat:
Right click on mydb under Physcial Schemata section, "Delete 'mydb'" option is grayed out. Even after reverse engineering some database, none of the schemas are allowed to be deleted.

Suggested fix:
Enable deletion of default "mydb" schema and any new schemas that are added.
[30 Oct 2009 2:21] Alfredo Kojima 
You can delete the schema by clicking the - button above the schema, at right of "Physical Schemata"
[30 Oct 2009 17:14] Dimitriy A 
Thanks, the workaround of clicking "minus" button deletes the schema.
[25 Nov 2009 9:06] Mike Lischke 
Fixed in 5.2
[1 Feb 2010 14:57] David Rutkin 
Thank you. I never considered that the "plus" and "minus" next to the "view as" options were add and delete. Assumed them to be zoom in and out, which in retrospect does not make sense.
[23 Feb 2010 18:52] Johannes Taxacher 
Bug #51427 has been marked as duplicate of this one
[23 Feb 2010 19:59] Cynthia Higginbotham 
I'd like to point out that Bug #51427 was filed on 5.2.16 OSS, so the problem either isn't fixed, or has regressed.
[14 Apr 2010 23:49] Alfredo Kojima 
Seems to be working in 5.2.18, I guess it was fixed by mikel's work on the menus.
[16 Apr 2010 11:30] Johannes Taxacher 
confirmed fixed in release
[20 Apr 2010 15:16] Tony Bedford 
An entry has been added to the 5.2.18 changelog:

In the MySQL Model page it was not possible to delete a schema by using the context sensitive menu in the Physical Schemata section.
[22 Feb 2018 22:01] Dennis Van Dusen 
On version 6.3.10 There is no apparent way to delete the schema -- AND -- you can change the schema name to ``` -- either way, not great.  
This is on a Mac, and there is no Physical Schema heading/tab. There is no + or _ except for zoom of the diagram. There is only a context menu stating Edit Schema, which will open up the detail window to the schema, but even there it does not ever provide a way to delete it.  When forward engineering, you can generate persistent errors by having this extra schema that does nothing. If you delete all tables (TABLE1), then the errors do not reappear even if you use ``` as a schema name.