数据库的建立

CREATE DATABASE database_name                                            --设置新建数据库的名称
    [ ON                                                                 --设置新建数据库的数据文件
                { [ PRIMARY ] [ <filespec> [ ,...n ]                     --设置文件
        [ , <filegroup> [ ,...n ] ]                                      --设置文件组
    [ LOG ON { <filespec> [ ,...n ] } ] }                                --设置新建数据库的日志文件
    ]                                                                    
    [ COLLATE collation_name ]                                           --设置数据库的排序规则名称
    [ WITH <external_access_option> ]                                    --设置外部与数据库之间的双向访问
]                         
[;]

To attach a database                                                     --附加数据库的语法
CREATE DATABASE database_name                           
    ON <filespec> [ ,...n ]                                              --指定附加的文件
    FOR { ATTACH [ WITH <service_broker_option> ]
        | ATTACH_REBUILD_LOG }                                           --指定地附加的文件，只限于读,写数据库
[;]

<filespec> ::=                                                           --<filespec>的语法内容
{
(
    NAME = logical_file_name ,
        FILENAME = { 'os_file_name' | 'filestream_path' } 
        [ , SIZE = size [ KB | MB | GB | TB ] ] 
        [ , MAXSIZE = { max_size [ KB | MB | GB | TB ] | UNLIMITED } ] 
        [ , FILEGROWTH = growth_increment [ KB | MB | GB | TB | % ] ]
) [ ,...n ]
}

<filegroup> ::=                                                          --<filegroup>的语法内容
{
FILEGROUP filegroup_name [ CONTAINS FILESTREAM ] [ DEFAULT ]
    <filespec> [ ,...n ]
}

<external_access_option> ::=                                             --<external_access_option>的语法内容
{
  [ DB_CHAINING { ON | OFF } ]
  [ , TRUSTWORTHY { ON | OFF } ]
}
<service_broker_option> ::=                                              --<service_broker_option>的语法内容
{
    ENABLE_BROKER
  | NEW_BROKER
  | ERROR_BROKER_CONVERSATIONS
}