Specifying DELETE statements in the SQL Query Builder

Use a DELETE statement to remove data from a database table.

Prerequisite: Before you specify a DELETE statement, create the statement in the SQL Query Builder.

To specify a DELETE statement in the SQL Query Builder:

  1. Add the table from which to delete data.
  2. Optional: Define a condition that specifies which rows of the table to delete. If you do not specify a condition, all rows of the target database table are deleted.
  3. Optional: Run the statement. Any row in the specified database table that matches the condition is deleted. A message in the SQL Results view indicates whether the statement ran successfully.
Related reference
SQL Query Builder for DELETE statements

Feedback