Check if database exists?

-- check db exist 1
select db_id('dbname')

-- check db exist 2
if not exists(select * from master.dbo.sysdatabases where name = 'dbname')
    print 'Database does not exist.'
else
    print 'Database exist.'

-- check db exist 3
if not exists(select * from sys.databases where name = 'dbname')
    --create database testing
    print 'Database does not exist.'
else
    print 'Database exist.'

-------- check table and store procedure exist --------
use qnet
if object_id('sp_name', 'P') is not null -- for sp
    print 'store procedure exist.'
else
    print 'store procedure not exist.'

if object_id('tb_name', 'U') is not null -- for table
    print 'table exist.'
else
    print 'tabel not exist.'
--------

Reference

• http://social.msdn.microsoft.com/.../7f21cb27-c939-4a89-98d7-0a8ec7ae0d8b
• http://bytes.com/groups/ms-sql/158373-how-check-does-some-database-exist
• http://www.sqlservercurry.com/2007/12/check-if-database-or-table-exists-using.html