• Another work around.

    declare @foreignkey sysname

    declare @referencingtable sysname

    declare @cmd sysname

    DECLARE fkey_cursor CURSOR FOR SELECT object_name(constid), object_name(fkeyid) from sysreferences

    OPEN fkey_cursor

    FETCH NEXT FROM fkey_cursor INTO @foreignkey, @referencingtable

    WHILE @@FETCH_STATUS = 0

    BEGIN

    select @cmd = 'alter table ' + @referencingtable + ' drop constraint ' + @foreignkey

    print @cmd

    exec (@cmd)

    FETCH NEXT FROM fkey_cursor INTO @foreignkey, @referencingtable

    END

    CLOSE fkey_cursor

    DEALLOCATE fkey_cursor

    GO