SYSSNAPSHOTS System Table

The SYSSSNAPSHOTS table describes the metadata for system snapshots.

The following table shows the contents of the SYSSNAPSHOTS system table.

Table snapshots both the data and indexes for the table.

SYSSNAPSHOTS system table
Column Name Type Length Nullable Contents
SNAPSHOTNAME VARCHAR 128 NO The name of the snapshot
SCHEMANAME VARCHAR 128 NO Schema name
OBJECTNAME VARCHAR 128 NO The name of the table or index
CONGLOMERATENUMBER BIGINT 19 NO The conglomerate number of the object
CREATIONTIME TIMESTAMP 29 NO The time at which the snapshot was taken
LASTRESTORETIME TIMESTAMP 29 NO The time at which the snapshot was most recently restored

See Also