Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Database Diagram Expand / Collapse
Author
Message
Posted Tuesday, May 21, 2013 1:39 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 10, 2013 2:29 AM
Points: 12, Visits: 30
Hi Guys.
After creating a new database diagram,i don't see any relationships.It's only showing the tables.I tried selecting the show relationships but nothing comes up.How do i get it to show the relationships?

Thanks
Post #1454843
Posted Tuesday, May 21, 2013 1:57 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 5:49 AM
Points: 5,336, Visits: 9,791
Do you have foreign key constraints in your database, and are they trusted?

John
Post #1454849
Posted Tuesday, May 21, 2013 2:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 10, 2013 2:29 AM
Points: 12, Visits: 30
Yes i do have and yes they are trusted.I did the diagram once before and it worked,but i didn't save it.
Post #1454852
Posted Wednesday, May 22, 2013 3:24 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 8:55 AM
Points: 51, Visits: 27
Try restarting the sql server service and close SSMS and log in again and try it once. It should work
Post #1455381
Posted Wednesday, May 22, 2013 7:14 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:44 AM
Points: 314, Visits: 4,128
subhajeetsur (5/22/2013)
Try restarting the sql server service


That sounds extreme and will almost certainly not solve this issue.

Not to doubt you but have you actually confirmed that you do have Foreign Key Constraints on the Tables you speak of?
Post #1455486
Posted Wednesday, May 22, 2013 7:23 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 8:41 AM
Points: 486, Visits: 422
Try checking the References between the tables again... I am sure you are missing something there.
Post #1455496
Posted Thursday, May 23, 2013 1:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, October 10, 2013 2:29 AM
Points: 12, Visits: 30
Thanks guys.I did checkup and spoke to the developer.There are NO foreign keys
Post #1455861
Posted Thursday, May 23, 2013 10:45 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, October 31, 2013 3:44 AM
Points: 314, Visits: 4,128
Glad you got it sorted.
Post #1456097
Posted Thursday, May 23, 2013 1:36 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 2:35 PM
Points: 975, Visits: 3,350
Why is a developer designing a database? That should be done by a database architect or a SQL DBA.

Andrew SQLDBA
Post #1456202
Posted Thursday, May 23, 2013 1:40 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
moeessack123 (5/23/2013)
Thanks guys.I did checkup and spoke to the developer.There are NO foreign keys


Why you have to ask a developer about that? Aren't you the DBA?


_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Post #1456205
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse