Description

To delete a record in SQL, you can use the DELETE operator.

To delete all records from a table, type DELETE followed by the name of the table, using this formula:

DELETE TableName;

Here is an example:

DELETE FROM Employees;

To delete a record, use this formula:

DELETE FROM TableName
WHERE Condition(s)

Here is an example:

DELETE FROM Employees
WHERE EmployeeNumber = 24685;