数据库原理与应用教程第八章习题，创建数据库

create database Student

on primary

(name='student2',filename='c:\data\student2.mdf',size=20,maxsize=100,filegrowth=1),

(name='student3',filename='c:\data\student3.mdf',size=20,maxsize=100,filegrowth=1)

log on

(name='studentlog1',filename='c:\data\studentlog1.ldf',size=10,maxsize=50,filegrowth=1),

(name='studentlog2',filename='c:\data\studentlog2.ldf',size=10,maxsize=50,filegrowth=1)

alter database Student add filegroup 分组

alter database Student add file(name='student1',filename='c:\data\student1.ndf',size=20,maxsize=unlimited,filegrowth=10%)

to filegroup 分组

---创建Warehouse stock数据库

create database Warehouse-stock

on

(name=Warehouse stock,

filename='c:\Warehouse stock\Warehouse-stock.mdf',

size=10MB

)

log on

(name=Warehouse stock_log,

filename='c:\Warehouse stock\Warehouse-stock_log.ldf'

size=2MB

)

go

注：两个路径要一致。

---创建数据库的格式

create database 数据库名

on

(name=逻辑文件名,

filename=路径,

size=文件初始容量,

maxsize=文件最大值,

filegrowth=递增容量

)

log on

(name= ,

filename= ,

size= ,

maxsize= ,

filegrowth=

)

go

---