Knowledgebase

If you have a large database and want to create a database diagram showing only the keys, this is possible by using the Microsoft SQL Server Management Studio:

In this example I used the Advantureworks 2008 R2 example database:

• Open Microsoft SQL Server 2008 R2 Management Studio and connect to the AdventureWorks database (http://msftdbprodsamples.codeplex.com/)
• Right click Database Diagrams and choose [New Database Diagram]

• Add all tables to you’re diagram, by selecting all tables clicking Add and then click Close

• Select all tables by pressing Ctrl + A

• Right click a table and click Table View > Keys

Result