EIDU interview question

What is the difference between DELETE, TRUNCATE and DROP in SQL.

Interview Answer

Anonymous

15 Mar 2024

DELETE to delete a line from a table. TRUNCATE to delete all lines within a table while keeping the table. DROP to delete the table completely.