2. Creating Databases : Drop a Database
 
Share this page                  
Drop a Database
To drop a database, use the destroydb command. You must be the DBA for the database or have the security privilege.
To drop 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).
The Application-By-Forms object file directories for any applications associated with the database (but not the source code directories) are deleted.
Caution!  Do not set ING_ABFDIR to be your default login directory or other directory that contains your own files. Your files can be inadvertently destroyed if a destroydb command is issued and dbname specified is the same name as the ING_ABFDIR directory.
Caution!  No prompt will ask you if you really want to destroy the database. Once you issue the destroydb command, it is irrevocable, that is it, there is no going back.