Friday, 19 August 2011

How to disable/enable all constraints and triggers for database?

To disable all constraints and triggers:
sp_msforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT all'
sp_msforeachtable 'ALTER TABLE ? DISABLE TRIGGER  all'
To enable all constraints and triggers:
exec sp_msforeachtable 'ALTER TABLE ? WITH CHECK CHECK CONSTRAINT all'
sp_msforeachtable
'ALTER TABLE ? ENABLE TRIGGER  all'


No comments:

Post a Comment