Created
June 21, 2019 10:12
-
-
Save alaawahbah/79250b51d372930d6f1aea9ae24a1950 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSOR | |
SET @Cursor = CURSOR FAST_FORWARD FOR | |
SELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_SCHEMA + '].[' + tc2.TABLE_NAME + '] DROP [' + rc1.CONSTRAINT_NAME + '];' | |
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1 | |
LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAME | |
OPEN @Cursor FETCH NEXT FROM @Cursor INTO @Sql | |
WHILE (@@FETCH_STATUS = 0) | |
BEGIN | |
Exec sp_executesql @Sql | |
FETCH NEXT FROM @Cursor INTO @Sql | |
END | |
CLOSE @Cursor DEALLOCATE @Cursor | |
GO | |
EXEC sp_MSforeachtable 'DROP TABLE ?' | |
GO |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment