Create a DELETE statement

You use a DELETE statement to specify criteria for deleting rows of data in an existing table.

In some environments, you cannot use SQL Assist to create DELETE statements.

To create a DELETE statement using SQL Assist:

  1. In the Outline view, click the main SQL Statement Properties node.
  2. In the Details area, click DELETE. A DELETE statement outline appears in the Outline view.
  3. Select a table to delete data from (DELETE FROM clause).
  4. Add search conditions to the DELETE statement (WHERE clause).
  5. Click OK. The SQL Assist window closes and the generated SQL code is sent to the client application.

Related tasks
Add search conditions to an SQL statement (WHERE or HAVING clause)
Add expressions
Create a SELECT statement
Create an INSERT statement
Create an UPDATE statement
Edit an SQL statement
Check SQL syntax
Run an SQL statement