Question

Which statement is used to delete all rows in a table without having the action logged?

a) DELETE

b) REMOVE

c) DROP

d) TRUNCATE

Answer 1

TRUNCATE statement removes all rows in a table without logging the individual row deletions. It uses fewer system and transaction log resources, which makes its execution fast. This statement is similar to the DELETE statement without the WHERE clause.

d) TRUNCATE