if i have a db with no relationships specified between the tables and i pull a few tables into a diagram in enterprise manager, it's not possible that relationships will be generated is it?

If there are no relationships defined, how could it possibly know which columns are related to which columns in which tables?

You can easily set up the relationships in the diagram, though, by clicking on the primary key column in the primary key table and dragging to the foreign key column in a foreign key table. A dialog box will pop up asking you to verify the primary and foreign key columns in the two tables, along with a couple other attributes of the relationship to be set up.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

i thought enterprise manager might have guessed because the primary and foreign keys that it connected in between those 2 tables were named the same, so i thought it may have assumed because they were named the same, no?

Well, just because they are named the same doesn't mean they are the same. I shudder to think how many tables I've seen where the primary key is named 'ID' and they have nothing to do with one another.

And it is more than reasonable that a foreign key constraint column could be named one thing in one table and quite another in the other table.

And even if the columns are referring to the same entity, it does not necessarily follow that you'd want the referential constraint always defined.

Such assumptions as you wish Enterprise Manager would make seem to me to potentially cause more trouble than they are worth, but that's just my opinion. In any case, EM doesn't do that. You have to define the foreign key relationships explicitly.



Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Hey Vagiroy,

congratulations!!!!!! I must give you an award. That is the worse question I have ever, ever seen in an internet forum. EVER!!!!

Just out of curiousity, are you saying that because you don't know how to assign relationships, you want the server to assign relationships for you?

There is no call for you to insult the original poster like that. P2P is a place where people can come for help. The poster asked a question seeking help; your response was not helpful and in fact it was insulting, downright rude, and boorish.

If you can't contribute in a meaningful way then I suggest you find another outlet for yourself. Nobody cares what you think about the nature of the questions posted here.

I don't think that in a forum such as this that there is any such thing as a stupid question; there are however, apparently, stupid answers.


Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Thanks for clearing that up for me Jeff.