Dropping a Database-Delete command - Firebird

When a database is no longer required, it can be deleted (dropped) from the server. Dropping a database deletes all files pertaining to the entire database—primary and secondary files, shadow files, and log files—and all its data.

The command to delete a database is DROP DATABASE, and it takes no parameters. In order to execute the command, you need to be logged into the database as its owner, as SYSDBA, or (on Linux/UNIX) as a user with system root privileges.

Syntax

While logged into the database you want to drop, use this statement to perform the drop:

DROP DATABASE;

A dropped database cannot be recovered, so

  • Be certain that you really want it to be gone forever.
  • Take a backup first if there is any chance that you will need anything from it in future.

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Firebird Topics