How to create a database?

The following Transact SQL command is used to create a database:

CREATE DATABASE database_name
[ ON [PRIMARY]
        [ <filespec> [,...n] ]
        [, <filegroup> [,...n] ]
]
[ LOG ON { <filespec> [,...n]} ]
<filespec> ::=
( [ NAME = logical_file_name, ]
FILENAME = ‘os_file_name’
[, SIZE = size]
[, MAXSIZE = { max_size | UNLIMITED } ]
[, FILEGROWTH = growth_increment] ) [,...n]
<filegroup> ::=
FILEGROUP filegroup_name <filespec> [,...n]

where,

• database_name is the name of the new database.
• ON specifies that the disk files used to store the data sections of the database and data files are explicitly defined. ON is needed when followed by a comma-separated list of [filespec] items that define the data files for the primary filegroup. The list of files in the primary filegroup can be followed by an optional, comma-separated list of [filegroup] items that define user filegroups and their files.
• PRIMARY specifies that the associated <filespec> list defines the primary file. The first file specified in the <filespec> entry in the primary filegroup becomes the primary file.
• LOG ON specifies that the disk files used to store the database log and log files are explicitly defined. It is followed by a comma-separated list of items that define the log files.
• NAME specifies the logical name for the file.
• FILENAME specifies the operating system (physical) file name.
• SIZE specifies the size of the file.
• MAXSIZE specifies the maximum size to which the file can grow.
• FILEGROWTH specifies the automatic growth increment of the file.
• FILEGROUP is the logical name of the filegroup.

• Download free practice test for mcad MCAD exam.
• Download free practice test for mcdba MCDBA exam.
• Become Microsoft MCP certified.
• Best exam simulation Microsoft mcsa-2003 download free trial.
• Become Microsoft MCSA 2000 certified.
• Download free practice test for mcsa-2000-to-2003 MCSA 2000 to 2003 exam.
• Download practice question and study guide for mcsa-to-mcse-2003 for exam.
• Pass MCSE in first attampt.
• Become Microsoft MCSE 2000 certified.
• Download free practice test for 70-228 SQL Server 2000 Administration exam.
• Become Microsoft SQL Server 2000 Design certified.

• Previous Entry: What is RJ-11?
• Next Entry: What is HTTP?