This is a prerelease version.

DROP SNAPSHOT (Enterprise only)

The DROP SNAPSHOT statement cancels a named snapshot.

Syntax Summary

This code block is a quick reference with all the parameters that you can use with the DROP SNAPSHOT statement.

For some practical examples, see << examples, Code Examples>>.
DROP SNAPSHOT [IF EXISTS] snapshot_name

Parameters

The DROP SNAPSHOT statement accepts the following parameters.

The snapshot_name parameter is required.

Parameter Description Example

IF EXISTS

Fail silently if the snapshot does not exist.

snapshot_name

The name of the snapshot to delete.

Examples

This section lists some example SQL queries that show you how to use the DROP SNAPSHOT statement.

Delete a Snapshot

DROP SNAPSHOT IF EXISTS track_trades_snapshot