what is the difference between truncate and delete command in sql query [duplicate]

Question

Possible Duplicate:
What’s the difference between TRUNCATE and DELETE in SQL

what is the difference between truncate and delete command in sql query

Answer 1

Delete marks each row as deleted (ghost record) and logs the individual row being deleted in the transaction log (in fully logged mode) or marks the page as being altered (in bulk logged). Delete permits a where clause, allowing the rows to be deleted, filtered.

Truncate removes the link from the table to the IAM and drops it on the floor, logging (bulk and full) the fact that it dropped the IAM, freeing up the space. Truncate removes all rows for the table, and can not be filtered.