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.

DROP SNAPSHOT [IF EXISTS] snapshot_name

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.	Delete a Snapshot
snapshot_name	The name of the snapshot to delete.	Delete a Snapshot

Parameter

Description

Example

IF EXISTS

Fail silently if the snapshot does not exist.

snapshot_name

The name of the snapshot to delete.

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

DROP SNAPSHOT IF EXISTS track_trades_snapshot