http://www2.sqlblog.com/blogs/adam_machanic/archive/tags/foreign+keys/primary+keys/default.aspxTags: foreign keys, primary keysenCommunityServer 2.1 SP2 (Build: 61129.1)http://www2.sqlblog.com/blogs/adam_machanic/archive/2010/04/04/rejuvinated-script-creates-and-drops-for-candidate-keys-and-referencing-foreign-keys.aspxMon, 05 Apr 2010 02:48:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:24043Adam Machanic12http://www2.sqlblog.com/blogs/adam_machanic/comments/24043.aspxhttp://www2.sqlblog.com/blogs/adam_machanic/commentrss.aspx?PostID=24043Once upon a time it was 2004, and I wrote what I have to say was a pretty cool little script . (Yes, I know the post is dated 2006, but that's because I dropped the ball and failed to back-date the posts when I moved them over here from my prior blog...(<a href="http://www2.sqlblog.com/blogs/adam_machanic/archive/2010/04/04/rejuvinated-script-creates-and-drops-for-candidate-keys-and-referencing-foreign-keys.aspx">read more</a>)<img src="http://www2.sqlblog.com/aggbug.aspx?PostID=24043" width="1" height="1">foreign keysindexesprimary keysScriptsunique constraints