Database diagram / schema in SSMS [ Edited ]

[gregcsharp]

Hello,

I downloaded the SDK for Act17. I could not find any diagram / schema of the Act17 Database. 

Where can I find this information please? This will help to perform queries in SSMS.

Thank you

Gregory

[Roy_Laudenslager · Accepted solution]

SSMS can create the diagram for you

[wellmet]

This is the most recent one I have.  I think there may be a newer one soon.

Stan

[gregcsharp]

Thank you Stan. I am not sure but I don't see it in your answer, did you miss something or I am not looking at the right sport?

Gregory

[Roy_Laudenslager · Accepted solution]

SSMS can create the diagram for you

[gregcsharp]

Thank you. I had to search for how to make a diagram from an existing DB in SSMS.

If someone else would look:

Expand DB folder -> right click on DB diagrams -> New DB diagram. Then select the tables wanted.

[wellmet]

I tried to attach the Act! 2010 Data Dictionary to my answer but it didn't attach.  Attachments are limited to 5MB or so.  Send me a private email with your email address and I'll email it to you.

Stan