Define delete statement


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

Example :

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