DROP SNAPSHOT

The DROP SNAPSHOT statement deletes 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.

See some practical examples.

sql

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	Do nothing if the snapshot does not exist.	Delete a Snapshot
snapshot_name	The name of the snapshot to delete.	Delete a Snapshot

Examples

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

Delete a Snapshot

sql

DROP SNAPSHOT IF EXISTS track_trades_snapshot