I am DBA for a Microsoft SQL Server 2008r2. Due to an audition, I need to provide data structure of my database, to people without an explicit IT background. I guess they would like the traditional format, with the tables as rectangles, with the fields listed inside, and the arrows between them to represent foreign keys. Is this something that is provided out-of-the-box by Microsoft?
In SQL Server Management Studio Object Explorer, expand a database and look at "Database Diagrams" to create one.
This require db_owner rights which you should have as a DBA (a.k.a sysadmin)
That looks good, but my database has 263 tables, how will they ever fit? May 13, 2013 at 8:56
email@example.com: You still have 263 tables to show with columns and relationships no matter what tool you use. This is your requirement. However, I would create several diagrams to cover clusters of related tables, even if it means repeating tables on some diagrams– gbnMay 13, 2013 at 9:36
If you can present it in a file format and not as a diagram, then have a look at DBScribe
I am particularly fond of the .CHM type output file, as it lists not only the tables with columns and data type, but also gives links to the dependencies.
I ended up using a combination of Techwriter and of Server Studio's own database diagrams.
SchemaCrawler for SQL Server is a free tool that generates diagrams of tables selected by means of regular expressions. I recommend that you generate more than one diagram, per "domain" in your system - for example, one diagram each for customers, sales, orders.
Here is an example diagram:
In addition, SchemaCrawler can also generate human readable HTML documentation of your schema.
Sualeh Fatehi, SchemaCrawler
It's not a direct solution your request but once you will have diagrams you can paste them into Dataedo documentation and generate nicely formatted document for auditors. (I'm the product manager of Dataedo.)
It will have detailed documentation of all database objects (with descriptions imported from DBMS) and your diagrams. You will be able to furtner descibe any other elelment.
Sample documentation: PDF