Community
Showing results for 
Search instead for 
Do you mean 
Reply

Database diagram / schema in SSMS

Accepted Solution Solved
Copper Super Contributor
Posts: 91
Country: USA
Accepted Solution

Database diagram / schema in SSMS

[ Edited ]

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


Accepted Solutions
Solution
Accepted by topic author gregcsharp
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,663
Country: USA

Re: Database diagram / schema in SSMS

SSMS can create the diagram for you

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Silver Super Contributor
Posts: 2,328
Country: USA

Re: Database diagram / schema in SSMS

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

 

Stan


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!
Copper Super Contributor
Posts: 91
Country: USA

Re: Database diagram / schema in SSMS

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
Solution
Accepted by topic author gregcsharp
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,663
Country: USA

Re: Database diagram / schema in SSMS

SSMS can create the diagram for you

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Super Contributor
Posts: 91
Country: USA

Re: Database diagram / schema in SSMS

[ Edited ]

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.

Silver Super Contributor
Posts: 2,328
Country: USA

Re: Database diagram / schema in SSMS

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


If you would like to get more out of ACT! you can find an ACT! Certified Consultant near you by going to:www.act.com/acc.
-------------------------------------------------------------------------------------
Stan Smith
ACT! Certified Consultant
ADS Programming Services, Inc.
(205) 222-1661
www.adsprogramming.com
www.actwebhosting.com
Click Here to Purchase Act!