How to check if database exists

[AnNguyen]

Please help.

How can i check the existence of a database prior to droping it.
i tried this the following statement but it didn't work

if EXISTS ( select * from sysobjects where name like 'database name')


Thanks for any help.

 

[LogicalmanUS]

AnNguyen,

Here you go, just change the name of the DB from TekTips to the name you want:

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'TekTips')
DROP DATABASE [TekTips]


Logicalman

 

[AnNguyen]

Thank you!
It's works and i appreciate your help.

 

[LogicalmanUS]

AnNguyen,

No problem. The error in your code was two-fold.

1. Databases are stored in the sysDatabases table of the Master Database (the sysobjects table stores details of Views ans SProcs)

2. You need to use the full three part naming protocol, (database.owner.objectname) then you can call it from any database (as long as the login as priveledges).

Happy coding,

Logicalman