CREATE <object type> <object name>
CREATE DATABASE <database name>
比較完整的語(yǔ)法列表:
日志文件和數(shù)據(jù)庫(kù)文件不要放在一塊磁盤(pán)上,爭(zhēng)搶磁盤(pán)IO,還有危害安全性。
CREATE DATABASE <database name>
[ON [PRIMARY]
([NAME = <'logical file name'>,]
FILENAME = <'file name'>
[,SIZE = <size in kilobytes,megabytes,gigabytes,or terabytes>]
[,MAXSIZE = <size in kilobytes,megabytes,gigabytes,or terabytes>]
[,FILEGROWTH = <kilobytes,megabytes,gigabytes,or terabytes|percentage>])]
[LOG ON
([NAME = <'logical file name'>,]
FILENAME = <'file name'>
[,SIZE = <size in kilobytes,megabytes,gigabytes,or terabytes>]
[,MAXSIZE = <size in kilobytes,megabytes,gigabytes,or terabytes>]
[,FILEGROWTH = <kilobytes,megabytes,gigabytes,or terabytes|percentage>])]
[CONTAINMENT = OFF|PARTIAL]
[COLLATE <collation name>]
[FOR ATTACH [WITH <service broker>] | FOR ATTCH_REBUILD_LOG | WITH DB_CHAINING ON| OFF| TRUSTWORTHY ON|OFF] ----需要實(shí)踐
[AS SNAPSHOT OF <source database name>]
[;]
實(shí)戰(zhàn):
CREATE DATABASE Accounting
ON
(
NAME = 'Accounting',
FILENAME = 'D:\AccountingData.mdf',
SIZE = 10,
MAXSIZE = 50,
FILEGROWTH = 5
)
LOG ON
(
NAME = 'AccountingLog',
FILENAME = 'D:\AccountingLog.ldf',
SIZE = 5MB,
MAXSIZE = 25MB,
FILEGROWTH = 5MB
)
sp_help
sp_helpdb
sp_helpdb 'dbname'
SQL SERVER 2012 第五章 創(chuàng)建和修改數(shù)據(jù)表 の CREATE語(yǔ)句