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.