CLEAR_DEPOT_PIN_POLICY_PROJECTION

Eon Mode only

Clears a depot pinning policy from the specified projection. After the object is unpinned, it can be evicted from the depot by any unpinned or pinned object.

This is a meta-function. You must call meta-functions in a top-level SELECT statement.

Behavior type

Syntax

CLEAR_DEPOT_PIN_POLICY_PROJECTION( '[[database.]schema.]projection' [, 'subcluster' ] )

Parameters

[database.]schema

Database and schema. The default schema is public. If you specify a database, it must be the current database.

projection

Projection with a pinning policy to clear.

subcluster

Clears the specified pinning policy from the subcluster depot. If you omit this parameter, the policy is cleared from all database depots.

Privileges

Superuser

See also

• Managing depot caching
• CLEAR_DEPOT_PIN_POLICY_PARTITION
• SET_DEPOT_PIN_POLICY_TABLE