0 votes
in Sql by
What is the difference between DELETE TABLE and TRUNCATE TABLE commands?

1 Answer

0 votes
by

DELETE TABLE syntax logs the deletes thus make the delete operation slow. TRUNCATE table does not log any information but it logs information about deallocation of data page of the table so TRUNCATE table is faster as compared to delete table.

DELETE table can have criteria while TRUNCATE cannot.

TRUNCATE table does not invoke trigger.

I had mentioned that TRUNCATE table can not be rolled back while delete can be.

Related questions

0 votes
asked Jul 7, 2020 in Sql by Robindeniel
0 votes
asked Jul 7, 2020 in Sql by Robindeniel
...