DROP DATABASE

Please note that this function is deprecated. Please use ibec_DropDatabase instead.


Deletes a specified database.

Syntax

DROP DATABASE 'filespec' USER 'username' PASSWORD 'password'
   [CLIENTLIB 'libfile'];
Argument Description
'filespec' A database file specification; file naming conventions are platform-specific.
USER 'username' Checks the username against valid user name and password combinations in the security database (Server security ISC4.GDB / SECURITY.FDB) on the server where the database will reside.
PASSWORD 'password' Checks the password against valid user name and password combinations in the security database on the server where the database will reside; can be up to 8 characters.
CLIENTLIB 'libfile' Client library file name; default: gds32.dll.

Description

DROP DATABASE deletes specified database, including any associated secondary, shadow, and log files. Dropping a database deletes any data it contains.

A database can be dropped by its creator, the SYSDBA user, and any users with operating system root privileges.

Example

execute ibeblock
as
begin
  drop database 'localhost/3060:c:\db1.fdb' user 'SYSDBA' password 'masterkey'
  clientlib 'C:\Program Files\Firebird\bin\fbclient.dll';
end