sql 判断数据库是否已存在

if exists(select * from master.dbo.sysdatabases where name = 's2723103005')
 begin
  drop database s2723103005
  print '已删除数据库s2723103005'
 end

create database s2723103005
on primary
(name=His_data,
 filename = 'd:/database/his_data.mdf',
 size=10,
 maxsize = 1500,
 filegrowth = 5
)
log on
(
 name=His_log,
 filename='d:/database/his_log.ldf',
 size=5,
 maxsize=500mb,
 filegrowth = 5mb
)