|
1.
|
Select Create > DELETE from the Query menu of the SQL Statement - Settings window. The DELETE Details window is displayed, with the tables and views of the database defined in the connection specification listed in the Table/view list.
|
|
2.
|
Type a name for the query in the Query name text entry field. The name must be unique within a particular access set, and it cannot contain double-byte characters.
|
|
3.
|
Type a description for the query in the Description text entry field. (The description is optional.)
|
|
4.
|
Select the table to delete data from in the Table/view list.
|
|
5.
|
Select WHERE clause to specify the WHERE clause of the DELETE statement.
|
|
6.
|
To save your query, select Apply.
|
Your query is saved in the access set and you are returned to the SQL Statement - Settings window. The name and description of your query are displayed in the Query name drop-down list and Description text field, respectively.
