TRUNCATE TABLE#
Removes all rows from a table as a fast metadata operation, without logging individual row deletions.
Syntax#
Remarks#
TRUNCATE TABLE is functionally similar to a DELETE statement with no WHERE
clause, but it is faster because it does not remove the rows one by one.
Examples#
Remove every row from a staging table:
TRUNCATE TABLE dbo.StagingProduct;
See also