For SQL Server 2008, what is the best way to automatically "draw up" the Database relation ship and table relationship too?
Is there any way to visualize database with this.
Tell me more
×
Database Administrators Stack Exchange is a question and answer site for
database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|
|
migrated from stackoverflow.com Dec 17 '12 at 11:42
|
You could use database diagrams, drag and drop your tables and use the designer to create the relationships for you. Open SSMS, expand the server, expand Databases, expand the database you want and it should be the first folder. If it asks to install things, say yes and away you go. |
|||
|
|
|
Alternatively you can use Visio if you have it to reverse engineer the database schema. Obviously you need the additional software but it's more flexible than the Database Diagram functionality in SSMS. |
|||
|
|
