SQL DELETE Statement

SQL > SQL Basics > SQL DELETE Statement

The SQL SELECT statement is the SQL command that removes data from an SQL database.

Anytime you want to remove rows from a SQL table use the SQL DELETE statement to remove the information.

The SQL DELETE command is used as follows.

SQL DELETE Statement Syntax

DELETE FROM <table_name>
WHERE <where_conditions>

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:

product_nbr product_name

1001 SQL Tool Light

1002 SQL Tool Professional

1003 SQL Tool Enterprise

DELETE product
WHERE product_nbr = '1003'

After the execution of the SQL DELETE statement, the table contains this data:

product_nbr product_name

1001 SQL Tool Light

1002 SQL Tool Professional