DELETE statement
To specify the example SQL DELETE statement
DELETE FROM EMPLOYEE
WHERE STATUS = 'RETIRED'
do the following:
1. In the Query name field, type a name for the DELETE statement.
2. In the Description field, type a description for the DELETE statement.
3. In the Table/view field, select EMPLOYEE from the drop-down list.
4. Select WHERE clause.
5. On the WHERE Details window, do the following:
a. In the Left operand field, select STATUS from the list.
b. In the Operator field, select = from the list.
c. In the Right operand field, type RETIRED.
d. From the Unary operator pull-down menu, select Right operand > String constant 'x'.
e. Select Apply.
Last modified date: 01/29/2015