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:
- 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 Data Output view indicates whether
the statement ran successfully.