What is the difference between DELETE and TRUNCATE in SQL?
-
A
DELETE is faster and cannot be rolled back; TRUNCATE can be rolled back
-
B
TRUNCATE removes all rows without logging individual deletions; DELETE logs each row deletion and can be rolled back
-
C
DELETE drops the table structure; TRUNCATE removes only data
-
D
There is no difference between DELETE and TRUNCATE