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 |
|
usafelix
Posting Yak Master
165 Posts |
 Posted - 2014-09-19 : 05:01:47
|
| i am using SSMS diagram tool generate ER diagram about 10 tables, but all table is without the line connector to show relationsip ? where is enable the line connector ? |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2014-09-19 : 07:55:56
|
| The lines represent foreign key constraints that are defined between tables. No constraints, no lines. You'll have to create those constraints and then re-create the diagram. |
 |
|
|
usafelix
Posting Yak Master
165 Posts |
Posted - 2014-09-19 : 12:15:34
|
| I have try use old software to generate ER diagram with lines. But I am forget this software name. It is used of SSMS must be manual to create the constrains ? Do u know which software can be auto-generate ER diagram with line constrains? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2014-09-19 : 15:53:05
|
| There's nothing I know of that auto-generates foreign key constraints. I believe the diagram tool in SSMS lets you create them by clicking and dragging, but I don't know for sure (I don't use it). ERWin and other diagramming tools can do this too. They will generate the ALTER TABLE...ADD CONSTRAINT commands to create the foreign keys. Or you can type them yourself in a query window. You can find the command syntax here:http://msdn.microsoft.com/en-us/library/ms190273.aspx |
|
|
|
|
|
|
SSMS diagam tools