Database Guide : VA Smalltalk database guide : More database techniques : Using the SQL Statement part : Defining a DELETE statement
Defining a DELETE statement
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')
 
1. Select Create > DELETE from the Query menu on the SQL Statement - Settings window.
The DELETE Details window is displayed and looks like this:
DELETE Details window
2. Select the STAFF table from the Table/view drop-down list.
3. Select WHERE clause to display the WHERE Details window.
4. Specify the WHERE clause expression:
5. (NAME= 'Sanders')
In this sample statement, all the rows for item Sanders are deleted.
6. 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.
Last modified date: 06/01/2018