Thursday, June 16, 2011

Truncate all tables in SQL

Here is how to truncate all tables

EXEC [sp_MSforeachtable] @command1="TRUNCATE TABLE ?"

No comments: