How Do I ... : Work with databases : Use the SQL editors : Use the DELETE Details window
Use the DELETE Details window
Use the UPDATE Details windowUse the UPDATE Details windowNo tip for this topicNo example for this topicUse the manual SQL editorUse the manual SQL editor
To interactively create SQL syntax for a DELETE statement:
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.
Last modified date: 08/13/2019