Empty all table or delete all data from all table by sp_MSforeachtable in SQL-SERVER 2005
As a developer, many times we need to delete all the records from all tables. For example we are developing one application in our development server. At the time of developing we must have entered lots of temporary data in our database; we shouldn’t upload all those data along with structure at live server. We should have to delete all dummy and temp data.
What will you do in that case? Execute delete statement for all foreign key table first and then delete from master tables????? Or else remove all constraint, check and triggers from all tables and then execute delete statement for all tables. Uuuufffffffff so tedious and boring job!!!! Isn’t it??????
March 5, 2009 at 12:26 pm
This is the perfact solution. What a magical StoredProcedure this is!
March 5, 2009 at 12:26 pm
This is the perfact solution. What a magical StoredProcedure this is!
March 5, 2009 at 2:39 pm
Hi Bihag, You can disable all triggers and enable it back also. sometime we have to include that in given SP.
March 5, 2009 at 2:39 pm
Hi Bihag, You can disable all triggers and enable it back also. sometime we have to include that in given SP.