SQL, how to delete data and tables
New Courses Coming Soon
Join the waiting lists
How to delete data from a SQL database table, and how to delete the table
To remove data from a table, use the DELETE FROM
command.
This deletes all rows:
DELETE FROM people;
You can use the WHERE
clause to only remove specific rows:
DELETE FROM people WHERE name='Flavio';
To delete a table instead of the data inside the table, use the DROP TABLE
command:
DROP TABLE people;
→ Read my SQL Tutorial on
The Valley of Code
Here is how can I help you:
- COURSES where I teach everything I know
- CODING BOOTCAMP cohort course - next edition in 2025
- BOOKS 16 coding ebooks you can download for free on JS Python C PHP and lots more
- Follow me on X