Specifying DELETE statements in the SQL Query Builder
Use a DELETE statement to remove data from a database table.
Before you begin
Before you specify a DELETE statement, create the statement in the SQL Query Builder.
Procedure
To specify a DELETE statement in the SQL Query Builder:
- Add the table from which to delete data.
- 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.
- 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.