To delete a database, the user name specified in LOGON must have DROP privilege on the database to be deleted.
To delete a database that is partially restored but unusable, delete the database with DELETE DATABASE. Executing the statement deletes all access privileges for all objects in the database. To release the locks that remain after the restore, run RELEASE LOCK before using DELETE DATABASE.