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.
Sql-server – Automatic create SQL database and table relationship
sql serversql-server-2008
Related Question
- Sql-server – SQL Server update and database transfer
- Sql-server – SQL Database automatic back up
- Sql-server – Automatic database file creation based on database file size in SQL Server 2008 R2
- Sql-server – How to create a Relation between a table and a many-to-many relation table
- Sql-server – Backing up a really huge SQL Server database
- SSMS – Missing Diagram Option in SQL Server 2008
- SQL Server Database Design – Table Relationship: One to Few (Many)
Best Answer
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.