Create a schema diagram from different databases

Question

Create a schema diagram from different databases

johnsql-193053

SSCommitted

Points: 1657
More actions
August 29, 2007 at 8:32 am

#118328

Buddies,
I created a database schema diagram in database A using EM’s graphic user interfaces. Because there is a table, called table Y, in another database, called database B, also involves in the schema diagram, I need to add that table to the diagram, too. If I use EM’s graphic user interfaces, when I open the table list dialog while I am standing on database A, I cannot see table Y from database B. Please give me any idea to add table Y ito the diagram.
Thank you in advance.
johnsql

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

it's tough, because the relationships in a schema diagram are based on foreign keys...since you can't have a foreign key that references outside of the database you are looking at, all you can hope to do is create a copy the table in the current database and add a reference to that, but that's just a work around.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Antares686 SSC Guru Points: 125444 More actions · Answer 2

The EM diagrammer is no designed to show those relationships. You need to use a tool live Visio or other than can work with multiple databases at a time.

johnsql-193053 SSCommitted Points: 1657 More actions · Answer 3

I am using EM's diagram GUIs to add tables to my db schema diagram, and when I add an extra table the the diagram, I will see a table list dialog and a dropdown lsit where I can pick a table and click OK. My problem, for other tables in a diffrent database, I cannot see from the dropdown list on the dialog.