DROP SHADOW
Drops (deletes) a shadow file from the current database
Available in
DSQL, ESQL
Syntax
DROP SHADOW sh_num [{DELETE | PRESERVE} FILE]
Parameter | Description |
---|---|
sh_num |
Shadow number — a positive number identifying the shadow set |
The DROP SHADOW
statement deletes the specified shadow for the current database.When a shadow is dropped, all files related to it are deleted and shadowing to the specified sh_num ceases.The optional DELETE FILE
clause makes this behaviour explicit.On the contrary, the PRESERVE FILE
clause will remove the shadow from the database, but the file itself will not be deleted.