Question

Which SQL command is used to remove all records from a table but keeps the table structure intact?

While DELETE can also remove records, TRUNCATE is a DDL command that quickly removes all rows from a table without logging individual row deletions.

A DROP

B DELETE

C TRUNCATE

D REMOVE

E CLEAR

More Computer knowledge Questions