Delete All (Dangerous!)
sql
1DELETE FROM students;Removes all rows, keeps table structure.
vs TRUNCATE
sql
1TRUNCATE TABLE students; -- Faster, resets counters
1DELETE FROM students;Removes all rows, keeps table structure.
1TRUNCATE TABLE students; -- Faster, resets counters