To Get ERD

  • How Can I get the ERD of a database created (with new tables) in Sql Server 2008 using SSMS

  • I don't know that SSMS really does that. There are plenty of tools out there for it, but I don't think SSMS is one of them.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • You can have SSMS create a database diagram, but it's not really a full ERD, and depending on how you have setup RI, it might not be completely correct.

    The main tools people seem to use to reverse engineer a database are Visio, ERWin, or ER/Studio.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply