DELETE

noun

say it: “dih-LEET” /dɪˈliːt/

The SQL statement that removes rows from a table.

What does DELETE do in a relational database?

DELETE — A statement that removes selected rows from a table.

DELETE FROM customer
WHERE customer_id = 1;

In a sentence

  • “A DELETE with a WHERE removed only the discontinued products.”

Level: Apprentice · More SQL terms at this level

Updated