DELETE
Published May 7, 2021Updated Jul 13, 2022
Contribute to Docs
The DELETE
command removes one or more existing rows from a table.
Syntax
DELETE FROM table WHERE condition;
Note: If the WHERE
clause is excluded, all rows in the table
will be deleted.
Examples
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 WHERE
clause:
DELETE FROM students;
All contributors
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.