destroydb(1sql)
Name
destroydb − destroy an existing database.
Syntax
destroydb [options] dbname
Description
The destroydb command removes all references to the database specified by dbname. The directories of the database, checkpoints, and journals, and all files in those directories are removed.
Options
−sIndicates that you are the ULTRIX/SQL system administrator.
−pRequires ULTRIX/SQL to ask if you are sure that you want to destroy the database.
−uusername
Allows the ULTRIX/SQL system administrator to use destroydb as the user specified by username. When the −u option is specified, it implicitly specifies the −s option as well.
Restrictions
To execute destroydb, you must either be the database administrator for dbname or be the ULTRIX/SQL system administrator (in which case the −s option must be specified).
Examples
Delete the database named empdata, assuming that you are the DBA for empdata:
destroydb empdata
Delete the database named emdata, assuming that you are the ULTRIX/SQL system administrator:
destroydb -s empdata
Delete the database named video, assuming that user brad is the DBA and you are the ULTRIX/SQL system administrator:
destroydb -ubrad video
Files
$II_DATABASE/ingres/data/default/dbname
Default directory for database files associated with dbname. The default location ii_database is mapped to this directory.
$II_JOURNAL/ingres/jnl/default/dbname
Default directory for journal files associated with dbname. The default location ii_journal is mapped to this directory.
$II_CHECKPOINT/ingres/ckp/default/dbname
Default directory for checkpoint files associated with dbname. The default location ii_checkpoint is mapped to this directory.