remove all foreign key constraints
method 1:
EXEC sp_msforeachtable "ALTER TABLE ? NOCHECK CONSTRAINT all"
method 2:
CREATE TABLE #Commands (Command VARCHAR(MAX)) INSERT #Commands SELECT 'ALTER TABLE ' + QUOTENAME(RC.CONSTRAINT_SCHEMA) + '.' + QUOTENAME(KCU1.TABLE_NAME) + ' DROP CONSTRAINT ' + QUOTENAME(rc.CONSTRAINT_NAME) + '; ' FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS AS RC INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS KCU1 ON KCU1.CONSTRAINT_CATALOG = RC.CONSTRAINT_CATALOG AND KCU1.CONSTRAINT_SCHEMA = RC.CONSTRAINT_SCHEMA AND KCU1.CONSTRAINT_NAME = RC.CONSTRAINT_NAME WHERE ORDINAL_POSITION=1 --SELECT * FROM #Commands DECLARE @Command VARCHAR(MAX) DECLARE curCommand CURSOR FOR SELECT Command FROM #Commands OPEN curCommand FETCH NEXT FROM curCommand INTO @Command WHILE @@FETCH_STATUS =0 BEGIN EXEC(@Command) FETCH NEXT FROM curCommand INTO @Command END CLOSE curCommand DEALLOCATE curCommand DROP TABLE #Commands
