MySQL Forums
Forum List  »  MySQL Workbench

Advanced Search
New Topic

Re: Workbench SE does NOT handle cross-db foreign key references?
Posted by: Michael G. Zinner
Date: October 06, 2008 10:58AM

WB handles cross-schemata FKs.

* When you reverse engineer a schema that has FK references to other schemata that are not imported, WB will create "placeholder" schema & tables to be able to link to those. When you forward engineer or synchronize your schema, these "placeholder" tables will not be considered, because they include a flag called "isStub".

* When you are modeling from scratch, you have to add the referred schemata and tables yourself and deselect when exporting / syncing. We yet have to expose the "isStub" so these are excluded automatically.

Hope that answers your question.

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Workbench SE does NOT handle cross-db foreign key references?
7225
lorenzo lucioni
October 06, 2008 02:55AM
Re: Workbench SE does NOT handle cross-db foreign key references?
3956
lorenzo lucioni
October 06, 2008 03:38AM
Re: Workbench SE does NOT handle cross-db foreign key references?
3885
Michael G. Zinner
October 06, 2008 10:58AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.