blog post

DELETE permanently removes records from a table.
DELETE can delete one or more records in a table.
Use the WHERE clause to DELETE only specific records.

The SQL DELETE syntax

The general syntax is:
DELETE table-name 

To delete specific records append a WHERE clause:
DELETE table-name 
 WHERE condition


Problem: Delete all products.
DELETE Product

Problem: Delete products over 100.
DELETE Product
 WHERE UnitPrice > 100

Problem: Delete customer with Id = 21.
DELETE Customer
 WHERE Id = 21

This is a more common scenario in which a single record is deleted.

  • Share This Story

Pleas give your valuable comments to improve the contents.

about author

Atul kumar shukla

I'm Atul Kumar Shukla, working as a web developer.
Welcome to my Blog. This is my personal blog where i post my own questions and answers , articles about ASP.Net., SQL Server, HTML, CSS, Jquery and many more..

Visit Profile

Leave a comment


Get More Stuff
Subscribing to the TheOneblogs newsletter and get intersting stuff and updates to your email inbox.
Your Email


Style Switcher

Change Color

×! We use cookies to improve your user experience. More information