subject:CREATE DATABASE
syntax:CREATE DATABASE db_name
[ ON [<filespec>] [, <filegroup>] ]
[ LOG ON [<filespec>] ]
[ COLLATE collation_name ]
[ FOR LOAD | FOR ATTACH ]
content:เป็นคำสั่งที่ใช้ในการสร้างฐานข้อมูล
<filespec> มีรูปแบบ ดังนี้
[ PRIMARY ] // เป็น default ของ filegroup
(
NAME = logical_file_name,
FILENAME = os_file_name,
SIZE = size,
MAXSIZE = { maxsize, UNLIMITED },
FILEGROWTH = growth_increment
)
<filegroup> มีรูปแบบ ดังนี้
FILEGROUP filegroup_name
(
NAME = logical_file_name,
FILENAME = os_file_name,
SIZE = size,
MAXSIZE = { maxsize, UNLIMITED },
FILEGROWTH = growth_increment
)
example:CREATE DATABASE function_in_th
ON
(
NAME = function_in_th,
FILENAME = "C:\database\function.mdf",
SIZE = 10,
MAXSIZE = 100,
FILEGROWTH = 10%
)
LOG ON
(
NAME = function_in_th_log,
FILENAME = "C:\database\function.ldf",
SIZE = 10MB,
MAXSIZE = 100MB,
FILEGROWTH = 10MB
)
