Published May 7, 2021Updated Jul 13, 2022
Contribute to Docs
DELETE command removes one or more existing rows from a table.
DELETE FROM table WHERE condition;
Note: If the
WHERE clause is excluded, all rows in the
table will be deleted.
The first example assumes there is a
students table and all the rows where the student has a
not_current status are deleted:
DELETE FROM studentsWHERE enrolled_status = 'not_current';
The next example is more destructive. The entire
students table will be deleted due to there being no
DELETE FROM students;
- Anonymous contributorAnonymous contributor3077 contributions
- Anonymous contributor
Looking to contribute?
- Learn more about how to get involved.
- Edit this page on GitHub to fix an error or make an improvement.
- Submit feedback to let us know how we can improve Docs.
Learn SQL on Codecademy
Analyze Data with SQLLearn to analyze data with SQL and prepare for technical interviews.
Includes 8 Courses
Design Databases With PostgreSQLLearn how to query SQL databases and design relational databases to efficiently store large quantities of data.
Includes 5 Courses