• Home
• org.bitbucket.bradleysmithllc.etlunit
• etlunit-sql-server-database
• 3.9.6
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

.bradleysmithllc.etlunit.etlunit-sql-server-database.3.9.6.source-code.sqlserver_drop_constraints.vm Maven / Gradle / Ivy

DECLARE @SQL_DROP VARCHAR(1024)

-- drop constraints
DECLARE con_cursor CURSOR
FOR
SELECT
	'ALTER TABLE [' + S.NAME + '].[' + T.NAME + '] DROP CONSTRAINT ' + FK.NAME
FROM
		SYS.TABLES T
JOIN
	SYS.SCHEMAS S
		ON
			T.SCHEMA_ID = S.SCHEMA_ID
JOIN
		sys.foreign_keys FK
			ON
				T.OBJECT_ID = FK.parent_object_id
WHERE
	S.NAME NOT IN ('SYS', 'INFORMATION_SCHEMA')

OPEN con_cursor

FETCH NEXT FROM con_cursor INTO @SQL_DROP

	WHILE @@FETCH_STATUS = 0
	BEGIN
		--PRINT(@SQL_DROP)
		EXEC(@SQL_DROP)

		FETCH NEXT FROM con_cursor INTO @SQL_DROP
	END

CLOSE con_cursor
DEALLOCATE con_cursor
;;