June 20, 2013 at 1:03 pm
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
June 20, 2013 at 1:10 pm
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/
June 20, 2013 at 1:14 pm
Thanks for replying...and my wife agrees with you.
~ Jeff
June 20, 2013 at 1:34 pm
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.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply