What is the difference between truncate and delete command in SQL query

Question

Possible duplicate:
What is the difference between TRUNCATE and DELETE in SQL

what's the difference between truncate and delete command in sql query

Answer 1

Deletes each line as deleted (phantom record) and registers a single line that is deleted in the transaction log (in full log mode), or marks the page as changed (logged in bulk). Delete allows the where clause, which allows you to delete lines, filter.

Truncate IAM , ( ) , IAM, . Truncate .