创建数据库

if exists (select * from sysdatabases where name='elizabeth')
drop database elizabeth

create database elizabeth
on
(
name='elizabeth_data',
filename='d:\elizabeth_data.mdf',
size=5mb,
maxsize=10mb,
filegrowth=5mb
)
log on--创建日志文件
(
name='elizabeth_log',
filename='d:\elizabeth_log.ldf',
size=2mb,
maxsize=10mb,
filegrowth=2mb
)
go