Drop Database

<< Create Database | IBExpert | Recreate Database >>

Drop Database

Databases can be dropped in IBExpert using the menu item Database / Drop Database. When an Firebird/InterBase database is dropped, all the metadata and data for this database are also deleted, along with all its secondary, shadow and log files ...permanently!

IBExpert asks for confirmation:

before finally dropping the database. Once dropped, it cannot be retrieved, so be extremely careful when using this command.

For those users preferring direct SQL input, the syntax is:

 DROP DATABASE;

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

See also:
DROP statement

back to top of page
<< Create Database | IBExpert | Recreate Database >>