Search This Blog

Friday, December 2, 2011

Clean all the data from tables in particular DB

 EXEC sp_msforeachtable 'alter table ? NOCHECK CONSTRAINT all'

EXEC sp_MSForEachTable 'delete from ?'

exec sp_msforeachtable 'alter table ? WITH CHECK CHECK CONSTRAINT all'