Re: create relationship between 2 tables from diferent 2 databases
Hi,
if this is a Workbench question (not sure about this) then it should go into the modelling forum. The diagrams in a model only show objects from a single schema, so it is not possible to construct a relationship between objects in different schemas. However, I'm not sure it is generally possible to reference objects between schemas. I can't find anything that would indicate this is possible in the MySQL Docs.
Mike
Mike Lischke, MySQL Developer Tools
Oracle Corporation
MySQL Workbench on Github:
https://github.com/mysql/mysql-workbench
On Twitter:
https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to
http://bugs.mysql.com
MySQL documentation can be found here:
http://dev.mysql.com/doc/refman/8.0/en/
Subject
Views
Written By
Posted
1066
October 31, 2012 03:59AM
Re: create relationship between 2 tables from diferent 2 databases
1091
November 01, 2012 02:29AM
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.