Database Guide
To create the example SQL DELETE statement
DELETE FROM EMPLOYEE
WHERE STATUS = 'RETIRED'
do the following:
- On the SQL Statement - Settings window, do the following:
- In the Connection alias field, select the connection
specification for the database that contains the EMPLOYEE table.
- In the Access set field, select the access set you want the
DELETE statement to be created in.
- From the Query pull-down menu, select Create
> DELETE.
- On the DELETE Details window, do the following:
- Specify the example DELETE statement.
- Select Apply.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]