Database Diagrams

• jhager

  SSCrazy

  Points: 2310

  More actions

  June 20, 2013 at 1:03 pm

  #294953

  Hi,

  A developer created several tables with PKs but no FKs. I used the Database Diagram feature to "map out" where the FKs should be, but when I saved the diagram it executed code to create those FKs. I didn't realize that this would happen -- I seem to remember (it seems so long ago) using SS 2005 and creating diagrams that did NOT automatically create anything.

  Any thoughts (except questions about my sanity) are much appreciated.

  Thanks,

  Jeff

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  June 20, 2013 at 1:10 pm

  #1626088

  jhager (6/20/2013)

  ---

  Hi,

  A developer created several tables with PKs but no FKs. I used the Database Diagram feature to "map out" where the FKs should be, but when I saved the diagram it executed code to create those FKs. I didn't realize that this would happen -- I seem to remember (it seems so long ago) using SS 2005 and creating diagrams that did NOT automatically create anything.

  Any thoughts (except questions about my sanity) are much appreciated.

  Thanks,

  Jeff

  The database diagram tool has always been the actual keys. At least since I have been working with sql server (since version 7). Unfortunately your memory is the only thing failing you on this one. 😀

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

• jhager

  SSCrazy

  Points: 2310

  More actions

  June 20, 2013 at 1:14 pm

  #1626089

  Thanks for replying...and my wife agrees with you.

  ~ Jeff

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  June 20, 2013 at 1:34 pm

  #1626093

  jhager (6/20/2013)

  ---

  Hi,

  A developer created several tables with PKs but no FKs. I used the Database Diagram feature to "map out" where the FKs should be, but when I saved the diagram it executed code to create those FKs. I didn't realize that this would happen -- I seem to remember (it seems so long ago) using SS 2005 and creating diagrams that did NOT automatically create anything.

  Any thoughts (except questions about my sanity) are much appreciated.

  Thanks,

  Jeff

  The database diagram always reflects the database exactly, and it was like that in prior versions also.