1.创建数据库
1.1创建未指定文件夹的数据库
CREATE DATABASE Bank
1.2创建指定事务和数据文件的数据库
CREATE DATABASE Bank
ON
(NAME = Bank_data,
FILENAME = 'D:\DATABASE\Bankdata.mdf' --已经新建D盘的database文件夹
SIZE = 10, /*
MAXSIZE = 50, 属性设置
FILEGROWTH = 5) */
LOG ON
(NAME = Bank_log,
FILENAME = 'D:\DATABASE\BankLOG.Ldf'
SIZE = 10MB, /*
MAXSIZE = 100MB, 属性设置
FILEGROWTH = 10%) */
1.3新建指定多个事务和数据文件的数据库
CREATE DATABASE Bank
CREATE DATABASE Bank
ON
PRIMARY --PRIMARY显式指定主文件
(NAME = Bank_data1,
FILENAME = 'D:\DATABASE\Bankdata1.mdf'