Check If A Perticular Database Exist Or Not

This is simple sql query:

USE master
Go


IF EXISTS ( SELECT  name
            FROM    sys.databases
            WHERE   name = 'MyDataBase' ) 
    PRINT 'Exists'
ELSE 
    PRINT 'Does Not Exists'
posted @ 2012-04-01 20:12  sandeepparekh9  阅读(303)  评论(0)    收藏  举报