DELETE statement

The DELETE statement is used to remove data from a specified database table or tables.

When you create the DELETE statement, you can optionally define a condition that specifies which rows of the database table to delete. Any row found in the specified database table that matches the condition is deleted.

If you do not specify a condition, all rows of the target database table are deleted.

See your database vendor documentation for information on the syntax of DELETE statements. There may be variations in syntax depending upon the database vendor that you are using.

 

Parent topic

Creating a DELETE statement