TRUNCATE table « Table « SQL Server / T-SQL Tutorial






3.8.TRUNCATE table
3.8.1.TRUNCATE TABLE removes all of the records in a table without logging a transaction.
3.8.2.Benchmarking the TRUNCATE and Delete