Purpose

The Drop Cache statement drops the cache defined on a remote table.

Syntax

DROP CACHE ON {remote_table} [IF EXISTS]

where:

remote_table
is the name of the remote table cache to be dropped. The remote table name can be a two-part name: schemaname.tablename. When specifying a two-part name, the specified remote table must be mapped in the specified schema, and you must have the privilege to drop objects in the specified schema.
IF EXISTS
specifies that an error is not to be returned if a cache for the remote table or view does not exist.

Notes

  • Caches on views are not supported.