建立数据库，用户必须是sysadmin或者dbcreator角色
CREATE DATABASE USER2
CREATE DATABASE USER8
ON
(NAME = 'User8_dat',
FILENAME = 'c:\mssql7\data\User8dat.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5 )
LOG ON
(NAME = 'User8_log',
FILENAME = 'c:\mssql7\data\User8log.ldf',
SIZE = 2MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB )
1 最简单的语法
CREATE DATABASE USER2 2 带参数的语法
CREATE DATABASE USER8ON(NAME = 'User8_dat', FILENAME = 'c:\mssql7\data\User8dat.mdf', SIZE = 10, MAXSIZE = 50, FILEGROWTH = 5 )LOG ON(NAME = 'User8_log', FILENAME = 'c:\mssql7\data\User8log.ldf', SIZE = 2MB, MAXSIZE = 25MB, FILEGROWTH = 5MB )参数说明：
Name：指定数据库的名称
FileName：指定数据库文件的物理路径
Size：指定数据库初始空间大小
MaxSize：制定数据库的最大空间
FileGrowth：指定数据库增长的大小