Saturday, April 20, 2013

TSql How to Truncate Table in Constraint


EXEC sp_MSForEachTable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'ALTER TABLE ? DISABLE TRIGGER ALL'
-- EXEC sp_MSForEachTable 'DELETE FROM ?' -- Uncomment to execute
DELETE FROM TABLE DBCC CHECKIDENT ('DATABASE.dbo.TABLE',RESEED, 0)
--TRUNCATE TABLE TABLE
EXEC sp_MSForEachTable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
EXEC sp_MSForEachTable 'ALTER TABLE ? ENABLE TRIGGER ALL'

No comments:

Post a Comment