Specifying DELETE statements in the SQL Query Builder

Use a DELETE statement to remove data from a database table.
Before you begin

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

About this task

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.

Feedback