TRUNCATE is also rollback the data.But difference is TRUNCATE can't mantian the log.
TRUNCATE is a DDL command and cannot be rolled back. All of the memory space is released back to the server. DELETE is a DML command and can be rolled back. Both commands accomplish identical tasks (removing all data from a table), but TRUNCATE is much faster.
More info at :
2016© C# Corner. All contents are copyright of their authors.
C# Corner. All contents are copyright of their authors.