1.创建数据库
1.1使用Transact-SQL创建数据库
CREATE DATABASE database_name
[ ON
[ PRIMARY ] [ < filespace > [,...n] ]
]
[ LOG ON
[ < filespace > [,...n] ]
];
<filespace>::=
(
NAME=logical_file_name
[,NEWNAME= new_logical_naem]
[, FILENAME = { ' os_file_name ' | 'filestream_path' } ]
[, SIZE = size [ KB | MB | GB | TB] ] ]
[, MAXSIZE = { maxsize [ KB | MB | GB | TB ] | UNLIMITED } ]
[, FILEGROWTH =growth_increment [ KB | MB | GB | TB | % ]
);
数据库创建实例
create database zooDB_data
on primary
(
name=zooDB_data,
filename='F:\SQL\zooDB_data.mdf', --右划线,此处需要单引号
size=5mb,
maxsize=15mb,
filegrowth=5%
) --至此运行,log为默认
log on