SQL | The DELETE Statement

• The DELETE statement is used to delete records in a table.
• The DELETE statement is used to delete rows in a table.
• SQL DELETE Syntax

Note: Notice the WHERE clause in the DELETE syntax. The WHERE clause specifies which record or records that should be deleted. If you omit the WHERE clause, all records will be deleted!

SQL DELETE Example

The “Persons” table:

Now we want to delete the person “Tjessem, Jakob” in the “Persons” table. We use the following SQL statement:

The “Persons” table will now look like this:

Delete All Rows

It is possible to delete all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact:

or