User Guide > User Guide > A. Command Reference > destroydb Command--Destroy a Database
Was this helpful?
destroydb Command--Destroy a Database
Permission required: DBA or system administrator.
The destroydb command removes an existing database. The directory of the database and all files in that directory are removed. You cannot destroy the iidbdb using destroydb.
The destroydb command has the following format:
destroydb dbname [-p] [-l] [-uusername] [-Ppassword]
dbname
Specifies the name of the database.
-p
Prompts you to be sure that you want to destroy the database.
-l
Confirms if the database is in use, and if in use, returns with an error message.
-uusername
Specifies the effective user for the session, as described in Standard Flags and Parameters
-Ppassword
Specifies the user password, not valid when using DBMS authentication.
Last modified date: 06/28/2024