if exists(
select name
from sys.databases
where name = 'tseting'
)
drop database tseting
go
create database testing
go
-- 创建数据库
drop database Library
create database Library
on primary
(
name = library_dat,
filename = 'F:\SQLSever\library\Librarydat.mdf',
size = 5,
maxsize = unlimited,
filegrowth = 1
)
log on
(
name = library_log,
filename = 'F:\SQLSever\library\Library.ldf',
size = 3,
maxsize = 10,
filegrowth = 10%
)