SQL SERVER 2012 第五章 建立和修改資料表 の CREATE語句

標籤：

CREATE <object type> <object name>

CREATE DATABASE <database name>

比較完整的文法列表： 記錄檔和資料庫檔案不要放在一塊磁碟上，爭搶磁碟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] ----需要實踐
　　[AS SNAPSHOT OF <source database name>]
[;]

實戰:

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 第五章 建立和修改資料表 の CREATE語句