SQL: Delete data from the database

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='Tony';

To delete a table instead of the data inside the table, use the DROP TABLE command:

DROP TABLE people;

Lessons this unit:

0: Introduction
1: Using TablePlus
2: Create a Postgres database
3: Create a new table
4: Add data to a table
5: Query data with SELECT
6: ▶︎ Delete data from the database
7: Update data with UPDATE
8: Null constraints
9: Unique and primary keys
10: Updating a table structure
11: Joins
12: DEMO Using Vercel Postgres COMING SOON