DROP SHADOW

`DROP SHADOW`

Drops (deletes) a shadow file from the current database

Available in

DSQL, ESQL

Syntax

DROP SHADOW sh_num
  [{DELETE | PRESERVE} FILE]

Table 1. `DROP SHADOW` Statement Parameter
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.

Who Can Drop a Shadow

The DROP SHADOW statement can be executed by:

Administrators
Users with the ALTER DATABASE privilege