Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement