This statement has the general form:
CREATE DATABASE db_name
[ON [PRIMARY] file_spec1 {, file_spec2} ...]
[LOG ON file_spec3 {, file_spec4 ...]
[COLLATE collation_name]
[FOR {ATTACH|ATTACH_REBUILD_LOG{]
db_name is the name of the database.
The maximum size of a database name is 128 characters.
The maximum number of databases managed by a single SQL Server system is 32,767.
All databases in SQL Server are stored in files.
These files can be explicitly specified by the system administrator or implicitly provided by the system.
If the ON option exists in the CREATE DATABASE statement, all files containing the data of a database are explicitly specified.