Nicholas Cain (10/30/2007)
I do not believe that the answer is correct.The question was the fastest way to delete every row in a table.
Delete and truncate are not the same thing.
Should the question have read "to remove all rows from a table" then I would agree with the truncate statement.
This does not take into account things like identity values which would continue from the most recent number rather than completely reseed post truncate.
The question doesn't take that into account, therefore nor should your answer. DELETE and TRUNCATE do indeed work differently, but both have the effect of deleting all rows. I can't see the difference between "delete every row in a table" and "remove all rows from a table".
John
Edit: actually, having looked at the choices again, neither of the DELETE options has correct syntax anyway.