DROP CACHE Statement

Enables you to drop a cached view.
DROP CACHE [ "catalog"."schema". ] view [FORCE ] 

“catalog”.”schema”

Specifies the catalog and schema of the data cache view.

view

Specifies the name of the data cache view.

FORCE Suppresses error messages if the cache to be dropped does not exist.
.