Sintaxa (eronata oarecum) de la CREATE DATABASE din SQL2000 este
CREATE DATABASE database_name
[ ON
[ < filespec > [
,...n ] ]
[ , < filegroup > [ ,...n
] ]
]
[ LOG ON { < filespec > [ ,...n ] } ]
[ COLLATE collation_name ]
[ FOR LOAD | FOR ATTACH ]
< filespec > ::=
[ PRIMARY ]
( [ NAME = logical_file_name , ]
FILENAME = 'os_file_name'
[ ,
SIZE = size ]
[ , MAXSIZE = {
max_size | UNLIMITED } ]
[ , FILEGROWTH =
growth_increment ] ) [ ,...n ]
Pentru
'os_file_name' BOL se spune
clar:
Is the path and file name used by the operating system when it
creates the physical file defined by the <filespec>. The path in
os_file_name must specify a directory on an instance of SQL Server.
os_file_name cannot specify a directory in a compressed file system.