DELETE

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;

Contributors

Interested in helping build Docs? Read the Contribution Guide or share your thoughts in this feedback form.

Learn SQL on Codecademy