Suggest an editImprove this articleRefine the answer for “How do you delete a record in a table?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)Deleting a record from a table is done with the `DELETE` command, e.g. `DELETE FROM Employees WHERE ID = 1;`. **Key point:** using `WHERE` is essential if you want to delete specific records - without it, every record in the table gets deleted, and once deleted, data is gone irreversibly unless a transaction with `ROLLBACK` is used.Shown above the full answer for quick recall.Answer (EN)ImageDeleting a record from a table is done with the `DELETE` command. **Syntax:** ```sql DELETE FROM Table_Name WHERE Condition; ``` **Example:** ```sql DELETE FROM Employees WHERE ID = 1; ``` **Explanation:** - `DELETE FROM Employees`, picks the table to delete a record from. - `WHERE ID = 1`, specifies the condition for which record to delete (without `WHERE`, **every record** in the table gets deleted). ### Notes - Using `WHERE` is essential when specific records need to be deleted. - Once deleted, a record is **irreversibly removed**, unless a transaction with `ROLLBACK` is used. > Put simply, `DELETE` is the SQL command for **removing one or several records** from a table based on a given condition.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.