This is a prerelease version.

View latest

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.

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.

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