Altering a foreing key referenced table

A_Tolmeijer

Hi all,

If you want to alter a table that is referenced by a foreign key, you are not allowed to do so. I created a script that dorps the constraints, then waits for you to click an OK button, and finally adds the foreign key constraints again. It copies the SQL generated script to the clipboard as well, and also dumps intermediate results. See instant share for details: share.linqpad.net/donn6t.linq.

Cheers,
Arno Tolmeijer

JoeAlbahari

Nice!

You could also have DropForeignKeyBuilder return an IDisposable, to make the following use possible:

using (DropForeignKeyBuilder (tableName))
{
    ... do DDL
}

so that the keys are restored if the DDL faults:

http://share.linqpad.net/b7qwds.linq

A_Tolmeijer

Absolutely brilliant! This is a good place for me to really start thinking IDsiposable :-)