快速理解T-SQL中的创建数据库Create database语法.docVIP

快速理解T-SQL中的创建数据库Create database语法 联机帮助的语法完整如下，看了就晕： CREATE DATABASE database_name [ ON [ [ ,...n ] ] [ , [ ,...n ] ] ] [ LOG ON [ ,...n ] ] [ COLLATE collation_name ][ FOR LOAD | FOR ATTACH ] :: [ PRIMARY ] [ NAME logical_file_name , ] FILENAME os_file_name [ , SIZE size ] [ , MAXSIZE max_size | UNLIMITED ] [ , FILEGROWTH growth_increment ] [ ,...n ] :: FILEGROUP filegroup_name [ ,...n ] 其实，绿色部分才是建库的语法，下面 :: 和 :: 只是替代语法中的部分。还原以后就是： CREATE DATABASE database_name [ ON [ PRIMARY ] [ NAME logical_file_name , ] FILENAME os_file_name [ , SIZE size ] [ , MAX