Technical Article

Truncate data from all tables in a database

,

This script will truncate data from all tables in a database

sp_msforeachtable @command1 = "print 'Truncating data from table ?'", @command2 = "TRUNCATE TABLE ?"

Rate

5 (1)

Share

Share

Rate

5 (1)