sql
how to truncate multiple tables in a particular database
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Sep 5, 2012, 2:17 AM
there is no direct method to trancate mutiple table in sql.
so you retrive all table and trancate it one by one.
please refer below link it might help you
http://devpinoy.org/blogs/keithrull/archive/2007/09/07/how-to-truncate-multiple-tables-in-sql-server-and-the-magic-of-sp-msforeachtable.aspx
but if you FK with table so you can not trancate table.
hope this will help you.