SQL DELETE Query

The SQL DELETE clause is used to delete existing records in a table permanently.

DELETE Query Syntax

DELETE FROM table_name
WHERE condition;


DELETE FROM table_name; //It delete all record(s) in a table//

Employee Table

A sample of EMPLOYEE records table & the name of table Employee. The column(s) of the Employee table [ID, EMPLOYEE_NAME, EMPLOYEE_EMAIL, ADDRESS, CITY, and COUNTRY]:

DELETE Query [WHERE clause]

DELETE FROM Employee
WHERE ID = 1;

Result Look Like

DELETE Query without [WHERE]

DELETE FROM Employee;

Result Look Like

Important Descriptions

• If WHERE clause is not use in DELETE query; you might loss all the rows from a table; that's why you should need to use WHERE condition if you want to delete a specific record.
• In the upper query deleted all records in a Employee table BUT the Employee table still visible.
• The WHERE clause is optional.
• Actually, WHERE clause is used to identifies the rows in the table that gets deteled.