<< CREATE DATABASE | IBEBlock | FOR ... DO loops >>

DROP DATABASE

Deletes specified database.

Syntax

  DROP DATABASE 'filespec' USER 'username' PASSWORD 'password'
     [CLIENTLIB 'libfile'];
ArgumentDescription
'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

back to top of page
<< CREATE DATABASE | IBEBlock | FOR ... DO loops >>