Database Diagram

  • 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

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

    John

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

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

  • 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?

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

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

  • Glad you got it sorted.

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

    Andrew SQLDBA

  • 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.
  • 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