What is the SQL DELETE Statement?
The SQL SELECT statement is the SQL command that removes data from an SQL database.
Why Use the SQL DELETE Statement?
Anytime you want to remove rows from a SQL table use the SQL DELETE statement to remove the information.
How To Use the SQL DELETE Statement
The SQL DELETE command is used as follows.
SQL DELETE Statement Syntax
SQL DELETE Statement Example
The following example deletes the row in the product table with product_nbr of '1001'.
Before the execution of the SQL DELETE statement, the table contains this data:
After the execution of the SQL DELETE statement, the table contains this data: