how to drop user defined database in sql server 2005?

Question

I am trying to drop a user-defined database, like so:

create database demo;
drop database demo;

But I get the error

Cannot drop the database 'demo', because it does not exist or you do not have permission.

There is nothing wrong with your code so my guess would be that you don't have permissions to delete the database. — Mikael Eriksson
– Mikael Eriksson, Commented Jun 1, 2011 at 11:25

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

One way to sort this out might be to run

SELECT name FROM sys.databases

to see if the database does exist.

Some helpful tips from MSDN:

To use DROP DATABASE, the database context of the connection cannot be the same as the database to be dropped. You could change your context to, for example USE master before running DROP
To execute DROP DATABASE, at a minimum, a user must have CONTROL permission on the database.

You might find some other useful information there that applies to your specific situation.

CommunityBot

11 silver badge

answered Jun 1, 2011 at 11:44

DOK

32.8k8 gold badges64 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Pankaj · Accepted Answer · 2011-06-01 11:34:35Z

0

create database demo;
drop database demo;

In the above code, if the database is deleted and again tried to delete the database which does not exists will give you the error as you mentioned

answered Jun 1, 2011 at 11:34

Pankaj

10.2k40 gold badges152 silver badges298 bronze badges