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: