SQL
DELETE Statement

DELETE statement is used to delete the records of a table.

Basic Syntax

DELETE FROM table_name WHERE condition;

Example

Specific Record

If you want to delete a specific customer details from customer table:

                    
 

    DELETE FROM Customers WHERE CustomerName='john';

All Record

If you want to delete all the records of customer table:

DELETE FROM Customers;