What is the difference between DELETE and TRUNCATE in SQL?
-
A
DELETE removes the table structure; TRUNCATE removes only data
-
B
DELETE can use a WHERE clause to remove specific rows; TRUNCATE removes all rows and cannot be filtered
-
C
TRUNCATE is slower than DELETE because it logs each row
-
D
There is no difference; they are interchangeable