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.