Explain DELETE statement in SQL Server.

The DELETE statement in used to delete the rows in a database table.

Ex :
Delete from Employees where EmployeeName = ‘Peterson’

This Query will delete the row that is having employee name as “Peterson”.

All the rows in a table can be deleted like,

Delete * from Employees
Or
Delete from Employees

This Query will delete all the rows in “Employees” table.