9. Creating Databases : Remove a Database
 
Share this page                  
Remove a Database
To remove a database, use the destroydb command. You must be the DBA for the database or have the security privilege.
To remove a database
Issue the following command at the operating system prompt:
destroydb dbname
The following occurs:
The database, checkpoint, journal, dump, and work directories for the database are deleted.
All traces of the database are removed from the master database (iidbdb).
Caution!  No prompt will ask you if you really want to destroy the database. Once you issue the destroydb command, the database is gone.