Drop Database

Delete a database from the sytsem. Minimum permission required: Database Manager. If the database has outstanding locks, clear them first, or use force to drop with locks.

Syntax

Syntax diagram for drop database.DBS-NAME

You can delete databases using drop database.

KeywordDescription

force

Delete a database that may have locked objects.

Example

drop database Sample.Basic force;

Deletes the database Sample.Basic, even if client users have outstanding locks on Sample.Basic.