SQL, how to delete data and tables
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;
→ Here's my latest YouTube video
→ I wrote 17 books to help you become a better developer, download them all at $0 cost by joining my newsletter
→ JOIN MY CODING BOOTCAMP, an amazing cohort course that will be a huge step up in your coding career - covering React, Next.js - next edition February 2025