NEWSubscribe to Receive Free E-mail UpdatesSubscribe

What Is SQL DELETE Statement And How To Use

The SQL DELETE statement allows you to delete a single record or multiple records from a table.

The syntax for the SQL DELETE statement is:
DELETE FROM table WHERE predicates;

Simple example:
DELETE FROM Employee WHERE emp_name = 'BOB';
This SQL DELETE statement would Delete all records from the employees table where emp_name is BOB.