SYSCS_UTIL.SYSCS_RESTORE_SNAPSHOT

The SYSCS_UTIL.SYSCS_RESTORE_SNAPSHOT system procedure restores a table or schema to the state it was in at the time the snapshot was created.

Snapshots include both the data and indexes for tables.

For more information, see the Using Snapshots topic.

Syntax

SYSCS_UTIL.SYSCS_RESTORE_SNAPSHOT( VARCHAR(128) snapshotName );

snapshotName

The name of the snapshot from which you are restoring.

Results

This procedure does not return a result.

Example

The following example restores the mySchema schema to its state when the named snapshot was created:

splice> CALL SYSCS_UTIL.RESTORE_SNAPSHOT( 'snap_myschema_070417a' );
Statement executed.