In this post, I will explain the SQL Delete Statement.
DELETE statement is used to delete a single or multiple rows from a table. We can use where clause with delete statement to delete selected row(s).
Few things to Note about Delete Statement -
1. Where clause with delete statement is optional
2. If where clause in a delete statement is not included, then all row(s) from table is deleted
3. If table row is referenced by foreign key, then row cannot be deleted
4. Delete operation on a table will not reset identity column counter
5. Delete operation cannot be rolled back if it is committed
Example -
DELETE FROM tbl_Employee
WHERE Id = 10