• 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.



    Shamless self promotion - read my blog http://sirsql.net