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.
• 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.