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  阅读(282)  评论(0编辑  收藏  举报