SYSCS_UTIL.SYSCS_RESTORE_SNAPSHOT system procedure restores a
table or schema to the state it was in at the time the snapshot was
Snapshots include both the data and indexes for tables.
For more information, see the Using Snapshots topic.
SYSCS_UTIL.SYSCS_RESTORE_SNAPSHOT( VARCHAR(128) snapshotName );
The name of the snapshot from which you are restoring.
This procedure does not return a result.
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.