Skip to content
≡

Administrator

Developer

Tools

External Tools

DROP DATABASE

DROP DATABASE#

Syntax#

drop_database ::=#

drop_database_image158

Prerequisites#

This SQL statement can only be executed by the SYS user in -sysdba administrator mode, and can only be executed during the PROCESS phase.

Description#

This statement is used to delete a database from the system.

database_name#

This is used to specify the name of the database to delete.

When this command is executed, all of the data, log files and log anchor files that were used by the database are also deleted.

Example#

<Query> Delate a database named mydb.

iSQL(sysdba)> DROP DATABASE mydb;
Checking Log Anchor files
[Ok] /home /altibase_home/logs/loganchor0 Exist.
[Ok] /home /altibase_home/logs/loganchor1 Exist.
[Ok] /home /altibase_home/logs/loganchor2 Exist.
Removing DB files
Removing Log files
Removing Log Anchor files
Drop success.