sql

Question

how to truncate multiple tables in a particular database

Jignesh Trivedi · Answer

hi 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.