How Do I...
To interactively create SQL syntax for a DELETE statement:
- 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.
- 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.
- Type a description for the query in the Description text entry
field. (The description is optional.)
- Select the table to delete data from in the Table/view
list.
- Select WHERE clause to specify the WHERE clause of the DELETE
statement.
- 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.
[ Top of Page | Previous Page | Next Page | Table of Contents ]