DELETE Statement in SQL

To delete a record from a table, we make use of DELETE statement.  After deleting a record, you can’t undo it.  If you want to delete a specific record, please add WHERE clause to it.  Syntax for DELETE statement is given below.

Delete All Records:

DELETE * FROM {Table_Name}

Delete Specific Record:

DELETE * FROM {Table_Name}  WHERE {Column_Name} = {Column_Value}

You May Also Like:

SELECT Statement in SQL INSERT INTO Statement in SQL with Example WHERE Clause in SQL How to Delete a File in C#/CSharp How to Detect Delete Key in Javascript