You can drop databases using IBConsole. Dropping a database deletes the current database and database alias, removing both data and metadata.
A database can be dropped only by its creator or SYSDBA.
To Drop a Database:
- 1. Select the database you wish to drop in the Tree pane.
- 2. Choose Database|Drop Database or select Drop Database from the Work pane.
- 3. A dialog asks you to confirm that you wish to delete the database. Click Yes if you want to drop the selected database, otherwise click No.
- Important: Dropping a database deletes all data and metadata in the database.