Which SQL command is used to remove all rows from a table quickly without logging individual row deletions?
- A DELETE
- B TRUNCATE
- C DROP
- D REMOVE
Answer
TRUNCATE
TRUNCATE is DDL that drops and recreates the table. It cannot take a WHERE clause, resets AUTO_INCREMENT and causes an implicit commit.





