SQL builder for DELETE statements

Use the panes of the SQL builder to create a DELETE statement.

A DELETE statement removes data from a database table.

SQL Source pane
Use this pane to review the DELETE statement as you build the statement in the Tables pane and the Design pane. You can also type changes directly in this pane. If you change the statement in this pane, you can parse the statement by moving the focus out of the pane or by saving the statement. If the parser considers the statement syntax valid, the Tables and Design pane are synchronized to reflect the updated statement.
Tables pane
Use this pane to add a table to the DELETE statement.
Design pane
Use the grid in this pane to specify the conditions that control which rows of the database to delete.
Statement
The name of the DELETE statement.
Column
Select a column in the table for which you want to specify a delete condition.Alternatively, you can select Build Expression and then press Enter and use the Expression Builder wizard to build an expression.
Operator
Select the operator to use for the delete condition.
Value
Select a column, specify a value, or select Build Expression to build an expression.
AND/OR
If you are specifying more than one condition, select the logical operator to use between this condition and the next condition. For example, if two conditions must both be true for a row to be deleted, click AND in the list for the first condition.
Related tasks
Specifying DELETE statements in the SQL builder

Feedback