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:
- 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.