SQL Schema Diagramming

Is there a way to print out or diagram the schema of an existing database. I need to provide the schema to a third party. I found a couple of threads about using enterprise diagrammer but I am using SQL Standard 2005. Is there an easy program to do this with or a query to pull this together. Would rather use a tool as this database has a hundred table and I don't know yet all of the keys.
circa62Asked:
Who is Participating?
 
kamindaConnect With a Mentor Commented:
You can use SQL Server database diagrams to do this. It comes with Management Studio itself. You can find it under database node in the Object Explorer.

This is a nice video tutorial

http://www.youtube.com/watch?v=wMbPRHeYvMU
0
 
circa62Author Commented:
I get a warning about needing to change the database owner in order to install this feature. Does changing the owner create issues? Or do I need to look for another method?
0
 
kamindaConnect With a Mentor Commented:
You must be in the db_owner role to create a diagram. Look at these articles from MSDN

http://msdn.microsoft.com/en-us/library/ms186345(v=sql.90).aspx

http://msdn.microsoft.com/en-us/library/ms189279(v=sql.90).aspx
0
 
circa62Author Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.