Browse by Tags

All Tags » Truncate (RSS)

Truncate All Tables - Part II

There are many methods to truncate all the tables in a database Part I of my post http://sqlblogcasts.com/blogs/madhivanan/archive/2007/08/27/truncate-all-tables-part-i.aspx shows executing the concatenated truncate table statements. This is other method...
Posted by Madhivanan | 5 comment(s)
Filed under: ,

Truncate All Tables - Part I

This procedure will truncate all the tables in the database To truncate all tables,I have seen the programmers using Cursors to get all tables and truncate them.This will avoid Cursors. Running this procedure will make SQL Server to slow down other tasks...
Posted by Madhivanan | 1 comment(s)
Filed under: ,