Skip
Arish's avatar

273. Delete All Rows


Delete All (Dangerous!)

sql
1DELETE FROM students;

Removes all rows, keeps table structure.

vs TRUNCATE

sql
1TRUNCATE TABLE students;  -- Faster, resets counters