SQL Server DELETE Statement

The SQL Server DELETE statement is used to delete particular record or all records from table. It’s comes under Data Manipulation Language(DML).

Syntax:

Delete particular record:
DELETE FROM Table_Name WHERE [condition]

Delete all records:
DELETE FROM Table_Name

Note: See how to CREATE , INSERT   & UPDATE data into Table

Example:

Delete particular record from table on the basis of condition

DELETE FROM tblemp2 WHERE IdentityNO='A100'

Delete all records from table

DELETE FROM tblemp2

 

Hope you enjoy the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.

Recommended SQL Server Post:

CREATE TABLE 

INSERT INTO

UPDATE