You can drop an existing cache using the Drop Cache statement (see Drop Cache (EXT)). If a cache is a relational cache, the Drop Cache statement drops the cache for the primary table as well as the caches for the related tables.

Note: When a cache is dropped, all the data in that cache is discarded.