Pros & Cons of TRUNCATE vs DELETE FROM

user_195583 0
Viewed 52337

Could someone give me a quick overview of the pros and cons of using the following two statements:

TRUNCATE TABLE dbo.MyTable

vs

DELETE FROM dbo.MyTable

It seems like they both do the same thing when all is said and done; but are there must be differences between the two.

sql-delete truncate sql-server-2008 tsql sql-server
11 Answers

Plus all the answers, another point to consider that Truncate will not trigger the delete trigger of the table, but delete statement will trigger the delete trigger of the table for each row.

user_19739330
Related