‹ BACK

SQL DELETE Statement

SQL DELETE Statement

The DELETE statement is used to delete records(rows) in a table.

Syntax

DELETE FROM table_name
WHERE some_column=some_value;

Note

Notice the WHERE clause in the SQL DELETE statement! The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted!
Read more.
WHERE-clause DELETE-statement

To check your knowledge the following tests are recommended:
Check your sql sql skills.