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
You can delete databases using drop database.
Keyword | Description |
---|---|
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.