You can drop an existing cache using the Drop Cache statement (refer to Drop Cache (EXT) in the DataDirect Connect Series for JDBC Reference). 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.