Skip to content

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:


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: