-- 创建数据库, 如果存在则删除
use master
go
if exists(select * from sysdatabases where name='student')
drop database student
go
create database student
on
(
name='student_data',
filename='student_data.mdf',
size=10mb,
maxsize=100mb,
filegrowth=1mb
)
log on
(
name='student_log,
filename='student_log.ldf',
size=10mb,
maxsize=100mb,
filegrowth=1mb
)