1 line script to truncate (delete all rows without logging the transactions) all tables within a SQL Server database.
[code='sql']
exec sp_MSforeachtable "truncate table ? PRINT'? truncated '"
[/code]
Truncate All Tables In Database Using sp_MSforeachtable
Leave a Reply
Photos from our Flickr stream
See all photos
-
CATEGORIES
- Events (4)
- General (18)
- Tips / HowTos (42)
- Top Stories (20)
-
ARCHIVES
- March 2010 (1)
- February 2010 (2)
- January 2010 (1)
- December 2009 (1)
- November 2009 (3)
- February 2009 (3)
- January 2009 (26)
- December 2008 (8)
- November 2008 (2)
- October 2008 (6)
- September 2008 (9)
- August 2008 (1)
- July 2008 (1)
- June 2008 (1)
- April 2008 (1)
- June 2007 (1)
- May 2007 (1)
- April 2007 (1)
- March 2007 (2)
- January 2007 (2)
- December 2006 (6)
- November 2006 (2)
- October 2006 (1)
- May 2006 (1)
- April 2003 (1)