Bug #53049 Forward Engineer SQL Script (Export): Placeholder Tables for Views
Submitted: 22 Apr 2010 9:16 Modified: 9 Jan 2015 10:32
Reporter: Kai Sautter (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.2.19 OS:Any
Assigned to: CPU Architecture:Any

[22 Apr 2010 9:16] Kai Sautter
Description:
The Forward Engineer SQL Script Wizard automatically includes create statement for placeholder tables for each view to create. The placeholder table is dropped again further down in the script prior to creating the view.

There might be scenarios, where these placeholder tables are desirable, but in some cases, it would also be desirable, not to have the CREATE and DROP statements for these placeholder tables in the resulting script. Therefore, an option should be available in the Wizard (first step) allowing the user to indicate, if the CREATE/DROP statements for the placeholder tables should be included in the resulting SQL script.

How to repeat:
1) Create a model including at least one view.
2) Forward Engineer the model including the views.

Suggested fix:
An option should be available in the Wizard (first step) allowing the user to indicate, if the CREATE/DROP statements for the placeholder tables should be included in the resulting SQL script.
[26 Apr 2011 12:37] Karsten Wutzke
+1 this is really annoying.