DROP SHADOW
From InterBase
Go Up to Statement and Function Reference (Language Reference Guide)
Deletes a shadow from a database. Available in gpre
, DSQL, and isql
.
DROP SHADOW <set_num>;
Important:
In SQL statements passed to DSQL, omit the terminating semicolon. In embedded applications written in C and C++, and in
In SQL statements passed to DSQL, omit the terminating semicolon. In embedded applications written in C and C++, and in
isql
, the semicolon is a terminating symbol for the statement, so it must be included.Argument | Description |
---|---|
<set_num> |
Positive integer to identify an existing shadow set |
Description: DROP SHADOW
deletes a shadow set and detaches from the shadowing process. The isql
SHOW DATABASE
command can be used to see shadow set numbers for a database.
A shadow can be dropped by its creator, the SYSDBA
user, or any user with operating system root privileges.
Example: The following isql
statement deletes a shadow set from its database:
DROP SHADOW 1;