Database Reference
In-Depth Information
In general, the
WHERE
clause of a
DELETE
query can take any form that encodes a list of
discrete primary key values. Thus the equality and
IN
operators are allowed; range oper-
ators are not. Performing a
DELETE
without a
WHERE
clause is also not allowed, as it
also fails to specify discrete primary key values.