CODEWITHSUNDEEP
sql-serverdatabasedatabase-design
dingchak
dingchak

Reputation: 43

Tool for database design

What's the best tool for figuring out database design of an already created database on a SQL Server?

I know about Erwin data modeler tool. Not sure how to use it. Do we have to install it on the SQL Server?

Upvotes: 2

Views: 662

Answers (2)

Shiva
Shiva

Reputation: 20935

You can use the Database Diagrams in SQL Server Management Studio. See Designing Database Diagrams (Visual Database Tools)

enter image description here

Upvotes: 1

Charles Bretana
Charles Bretana

Reputation: 146469

IN SQL Server you can click on the "Database Diagrams" node in SQL Enterprise Manager, install the admin tables it asks for, and create an ERD diagrams from the existing tables schema...

Upvotes: 1

Related Questions