DELETE (Transact-SQL)

To delete all the rows in a table, use TRUNCATE TABLE. TRUNCATE TABLE is faster than DELETE and uses ...

msdn.microsoft.com