Friday, June 22, 2012

Deleting All Keys or constraints from database


DECLARE

@Sql NVARCHAR(500) DECLARE @Cursor CURSOR

SET

@Cursor = CURSOR FAST_FORWARD FOR

SELECT DISTINCT sql = 'ALTER TABLE [' + 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

No comments:

Post a Comment