Delete a database from the sytsem. Minimum permission required: Database designer. If the database has outstanding locks, clear them first, or use force to drop with locks.
drop database Sample.Basic force;
Deletes the database Sample.Basic, even if client users have outstanding locks on Sample.Basic.
You can delete databases using drop database.
Key Phrase | Explanation |
---|---|
force | Delete a database that may have locked objects. |
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |