DELETE(QUEL) 1/26/79 DELETE(QUEL) NAME delete - delete tuples from a relation SYNOPSIS delete tuple_variable [where qual] DESCRIPTION Delete removes tuples which satisfy the qualification qual from the relation that they belong to. The tuple_variable must have been declared to range over an existing relation in a previous range statement. Delete does not have a target_list. The delete command requires a tuple variable from a range statement, and not the actual relation name. If the qualification is not given, the effect is to delete all tuples in the relation. The result is a valid, but empty relation. To delete tuples from a relation, you must be the owner of the relation, or have delete permission on the relation. EXAMPLE /* Remove all employees who make over $30,000 */ range of e is emp delete e where e.sal > 30000 SEE ALSO destroy(quel), permit(quel), quel(quel), range(quel) BUGS - 1 -