Dropping a Shadow (Creating Databases)
From InterBase
Go Up to Creating Databases (Data Definition Guide)
To stop shadowing, use the shadow number as an argument to the DROP SHADOW
statement. DROP SHADOW
deletes shadow references from a database’s metadata, as well as the physical files on disk.
A shadow can be dropped by its creator, the SYSDBA
user, or any user with operating system root privileges.
DROP SHADOW Syntax:
DROP SHADOW set_num;
The following example drops all of the files associated with the shadow set
number 1:
DROP SHADOW 1;
If you need to look up the shadow number, use the
isql
command SHOW DATABASE
.
SHOW DATABASE;
Database: employee.ib Shadow 1: 'employee.shd' auto PAGE_SIZE 1024 Number of DB pages allocated = 392 Sweep interval = 20000