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.