Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

re: Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

Patrick Cahill — Mon, 05 Apr 2010 14:44:51 GMT

Thank you for the script Adam. I don't know how many times I have had to go find all the FKs so I could make a change to a column. They will save me a lot a pain in some development projects that we are working on.

re: Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

Uri Dimant — Tue, 06 Apr 2010 05:17:26 GMT

Thanks Adam ,as usual, very usefull script

re: Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

Uri Dimant — Tue, 06 Apr 2010 05:17:28 GMT

Thanks Adam ,as usual, very usefull script

re: Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

Uri Dimant — Tue, 06 Apr 2010 05:17:29 GMT

Thanks Adam ,as usual, very usefull script

re: Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

Brian Tkatch — Wed, 07 Apr 2010 14:51:25 GMT

bookmarked, thanx adam!

re: Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

Ron Holyfield — Mon, 12 Apr 2010 18:06:08 GMT

Hope to not have to deal with this but bookmarked in case - Thx.

re: Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

Kimberly L. Tripp — Thu, 22 Apr 2010 22:26:44 GMT

Hey there Adam (et al) - If you're interested in the code that I use to generate the following:

* disabling the NC indexes

* disabling the FKs

This is where you'd change the CL index...

* re-enabling (and very important RECHECKING! of the FK constraints)

* REBUILDS of the disabled nonclustered indexes.

All of this is described and detailed in the SQL Server Magazine Q&A where I answer how to Change the Definition of a Clustered Index. Here's the link: http://www.sqlmag.com/blogs/sql-server-questions-answered/sql-server-questions-answered/tabid/1977/entryid/12749/Default.aspx.

It's not a script (like yours) but more the process and TSQL to change a clustered index.

Cheers!

re: Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

Adam Tappis — Mon, 26 Apr 2010 03:18:56 GMT

Great script, thanks. Hope you don't mind me mentioning but you have left one reference to INFORMATION_SCHEMA, on the first line :)

re: Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

LLL — Thu, 21 Apr 2011 13:17:47 GMT

A MILLION THANKS! This script is perfect for what I need. I want to be able to truncate the tables in a schema, pull a copy of data in, and then re-apply the constraints. I added an @FKOnly parameter to determine if foreign keys only are needed in output. Also added @DropOrCreate parameter to get drops all at once and creates separately as I'm looping a call to this SP for every object.

re: Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

Bigpa — Thu, 28 Jul 2011 14:15:52 GMT

Excellent, your script has really helped me out !

re: Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

Binyam — Fri, 25 May 2012 14:58:29 GMT

Many thanks Adam for all the scripts. You are making me lazy !!??

re: Rejuvenated: Script Creates and Drops for Candidate Keys and Referencing Foreign Keys

gaol — Mon, 30 Jul 2012 10:16:04 GMT

why when i run the script error near in 'kc.key_columns'? any body can give me the example? because i don't know how to replace like [-- Create Candidate Keys] in table