SQL DELETE


David Haertzen David Haertzen, Tutorial Author
Check out our
Data Warehousing Tutorial.
Previous | Next

SQL > SQL Basics > SQL DELETE Statement


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

 
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_nbrproduct_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_nbrproduct_name
1001 SQL Tool Light
1002 SQL Tool Professional

Copyright© 1999-2015, First Place Software, Inc.