Take the 2-minute tour ×
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.

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.

share|improve this question

migrated from stackoverflow.com Dec 17 '12 at 11:42

This question came from our site for professional and enthusiast programmers.

2 Answers 2

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.

share|improve this answer

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.