Database Guide
To specify the example SQL DELETE statement
DELETE FROM EMPLOYEE
WHERE STATUS = 'RETIRED'
do the following:
- In the Query name field, type a name for the DELETE
statement.
- In the Description field, type a description for the DELETE
statement.
- In the Table/view field, select EMPLOYEE from the
drop-down list.
- Select WHERE clause.
- On the WHERE Details window, do the following:
- In the Left operand field, select STATUS from the
list.
- In the Operator field, select = from the
list.
- In the Right operand field, type RETIRED.
- From the Unary operator pull-down menu, select Right
operand > String constant
'x'.
- Select Apply.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]