Skip to content

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;
→ Download my free SQL Handbook!

THE VALLEY OF CODE

THE WEB DEVELOPER's MANUAL

You might be interested in those things I do:

  • Learn to code in THE VALLEY OF CODE, your your web development manual
  • Find a ton of Web Development projects to learn modern tech stacks in practice in THE VALLEY OF CODE PRO
  • I wrote 16 books for beginner software developers, DOWNLOAD THEM NOW
  • Every year I organize a hands-on cohort course coding BOOTCAMP to teach you how to build a complex, modern Web Application in practice (next edition February-March-April-May 2024)
  • Learn how to start a solopreneur business on the Internet with SOLO LAB (next edition in 2024)
  • Find me on X

Related posts that talk about database: