Database Guide
You can create DELETE statements to delete existing data in a
database.
In this example you will use the SQL Editor to create the following DELETE
statement:
DELETE FROM STAFF
WHERE (NAME = 'Sanders')
- Select Create > DELETE from the
Query menu on the SQL Statement - Settings window.
The DELETE Details window is displayed and looks like this:

- Select the STAFF table from the Table/view drop-down
list.
- Select WHERE clause to display the WHERE Details window.
- Specify the WHERE clause expression:
(NAME= 'Sanders')
In this sample statement, all the rows for item Sanders are deleted.
- Select Apply to save your WHERE clause and return to the DELETE
Details window. If you want, you can name and save your DELETE
statement.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]