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 students
WHERE 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 SQL on Codecademy