SQL – Delete Statement
Table Of Contents:
- What Is Delete Statement?
- Syntax Of Delete Statement.
- Examples Of Delete Statement.
(1) What Is Delete Statement?
- The
DELETEstatement is used to delete existing records in a table.
(2) Syntax Of Delete Statement?
Syntax:
DELETE FROM table_name WHERE condition;(3) Examples Of Delete Statement?
Demo Data:
Example-1: Delete A Single Record
DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';
Example-2: Delete All Record
DELETE FROM Customers;