DROP DATABASE (IBEBlock)
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
back to top of page
<< CREATE DATABASE | IBEBlock | FOR ... DO loops >>
