Utilizor
Contact Us

SQL Delete

Delete existing records.

SQL DELETE Statement

The DELETE statement is used to delete existing records in a table.

Syntax

DELETE FROM table_name
WHERE condition;

Be careful when deleting records! If you omit the WHERE clause, ALL records in the table will be deleted!

Delete All Records

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:

DELETE FROM table_name;