Post reply

Database Diagram

  • May 21, 2013 at 1:39 am

    #274095

    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

  • May 21, 2013 at 1:57 am

    #1616863

    Do you have foreign key constraints in your database, and are they trusted[/url]?

    John

  • May 21, 2013 at 2:00 am

    #1616866

    Yes i do have and yes they are trusted.I did the diagram once before and it worked,but i didn't save it.

  • May 22, 2013 at 3:24 am

    #1617319

    Try restarting the sql server service and close SSMS and log in again and try it once. It should work

  • May 22, 2013 at 7:14 am

    #1617416

    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?

  • May 22, 2013 at 7:23 am

    #1617425

    Try checking the References between the tables again... I am sure you are missing something there.

  • May 23, 2013 at 1:53 am

    #1617726

    Thanks guys.I did checkup and spoke to the developer.There are NO foreign keys

  • May 23, 2013 at 10:45 am

    #1617932

    Glad you got it sorted.

  • May 23, 2013 at 1:36 pm

    #1618025

    Why is a developer designing a database? That should be done by a database architect or a SQL DBA.

    Andrew SQLDBA

  • May 23, 2013 at 1:40 pm

    #1618028

    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.

  • May 24, 2013 at 12:37 am

    #1618112

    I work for a retail clothing company so when we bought the POS package the developer done everything.I was more in the technical/support side of things.Recently my company decided on sending me for the mcse dataplatform course.So im just starting out as a dba.I did not know much about the database side of things.So i'm still a newbie when it comes to SQL

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply