Syntax options:
DROP CACHE row-cache-name CASCADE | DROP CACHE row-cache-name
RESTRICT
Deletes the specified row cache from the database. If the mode is
RESTRICT, then an exeption is raised if the row cache is assigned
to a storage area. If the mode is CASCADE, then the row cache is
removed from all referencing storage areas.
The default is RESTRICT if no mode is specified.