SQL Queries - CAST Central Base - Queries on snapshots - How to change the label of the snapshot using UPDATE query

Purpose of Query

The query will result in changing the label of the snapshot

Applicable CAST Version

Applicable RDBMS

Query for CSS

UPDATE <central>.dss_snapshots
SET snapshot_name = '<new_label>'
WHERE snapshot_id = <snapshot_id>;  
 
<central> - name of the central where snapshot is generated
<new_label> - desired label
<snapshot_id> - snapshot id of a particular snapshot can be obtained from dss_snapshots table

Query result example

Query result interpretation

The above query has changed the snapshot_name to Test_snapshots

Query for Oracle

Same as CSS2

Query result example

Query result interpretation

Query for SQL server

Same as CSS2

Query result example

Query result interpretation

Notes/comments

Related Pages