Dropping a Shadow (Creating Databases)

From InterBase
Jump to: navigation, search

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

Advance To: