SQLite for Beginners: DELETE FROM WHERE & DROP TABLE Explained | Episode 11

SQLite for Beginners: DELETE FROM WHERE & DROP TABLE Explained

Managing data in SQLite often requires removing unwanted records or entire tables. This guide covers how to use the DELETE FROM ... WHERE statement to remove specific rows safely, the risks of omitting the WHERE clause, and how to use DROP TABLE to delete an entire table from your database.

Code

-- Delete a single student by name
DELETE FROM students WHERE name = 'John Doe';

-- Delete all students with status 'withdrawn'
DELETE FROM students WHERE status = 'withdrawn';

-- Delete all failing grades (assuming grade below 60 is failing)
DELETE FROM grades WHERE score < 60;

-- WARNING: This deletes ALL rows in the table!
-- Use with extreme caution
DELETE FROM students;

-- Remove the entire table and all its data permanently
DROP TABLE students;

Key Points

• DELETE FROM ... WHERE removes only rows matching the specified condition.
• Omitting the WHERE clause in DELETE deletes every row in the table.
• DROP TABLE deletes the entire table structure and all its data permanently.
• Always double-check your WHERE conditions to avoid accidental data loss.
• Use transactions or backups when performing destructive operations for safety.