DELETE Statement in SQL

sqlTo 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}

  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •