Database Guide


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:
    1. In the Left operand field, select STATUS from the list.
    2. In the Operator field, select = from the list.
    3. In the Right operand field, type RETIRED.
    4. From the Unary operator pull-down menu, select Right operand > String constant 'x'.
    5. Select Apply.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]