Specifying DELETE statements in the SQL 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 builder.

To specify a DELETE statement in the SQL 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 Data Output view indicates whether the statement ran successfully.
Related reference
SQL builder for DELETE statements

Feedback