Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 db diagram

Author  Topic 

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2011-06-17 : 16:08:11
As part of documentation, I have created a database diagram using MS Visio (db has 250+ tables). And converted to pdf format.
But the tables and relations are not that much clear to present to some non-technical guys.

Is there any way in MS SQL to produce or export the schema?

I need schema to be properly documented. Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-17 : 16:09:06
An ERD is the best way for non-technical guys. Showing them the raw DDL (schema) is not something that non-technical people will be able to understand.

Unless I'm misunderstanding you...

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -