Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2003-05-12 : 02:55:53
|
| Hello ,I am trying to create a database diagram displaying all the tables and their keys . There is a facility i remember which can show me the links to the tables and the columns and references . I am unable to get or locate that feature as I think i just can"t recollect where it is ? Need to refresh . Need your help in this regard pl . Thanks a lot . |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-12 : 03:03:15
|
| It's in enterprise manager, expand the database in question, diagrams. |
 |
|
|
admin001
Posting Yak Master
166 Posts |
Posted - 2003-05-12 : 03:11:03
|
| Hello Andraax ,Thanks for your reply . I have already created a diagram and I would like to know how can we see the joins ( arrow lines ) between the tables in a form of a diagram . Any ideas ????Thanks once again . |
|
|
|
beanz
Starting Member
35 Posts |
Posted - 2003-05-12 : 03:15:54
|
| It has always been my experience that SQL/Enterprise Manager will automatically show the relationships between fields, if they exist.If the relationships don't exist then the diagram can be used to create them by dragging the fields from table to table.Otherwise it may be a "right-click" option??HTH,DannyEdited by - beanz on 05/12/2003 03:17:10 |
|
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-12 : 03:26:39
|
| The relationships must exist in the database. Eg foreign keys.When you drag/drop, you actually run SQL code to create the foreign keys, so don't do it just to create a diagram, do it do ensure data integrity in your database. |
|
|
|
|
|
|
Database diagram.