使用T-SQL创建数据库:
T-SQL创建数据库的语法:
create database name
on primary
(
/*主数据库文件属性*/
name='name_data'
filename='d:\name_data.mdf',
size=5mb,
maxsize=100mb,
filegrowth=15%
),
(
/*次数据库文件的属性*/
name='name_data2',
filename='d:\name_data2.ndf',
size=5mb,
maxsize=100mb,
filegrowth=15%
)
log on
(
/*日志文件的属性*/
name='name_log',filename='d:\name_log.ldf',
size=5mb,
maxsize=100mb,
filegrowth=15%
)
go