Sql:How to create database in sql server 2005
CREATE DATABASE database_name
[ ON [ PRIMARY ] [ < filespec >] ]
{ LOG ON [ < filespec > ] ]
< filespec > : : =
( [ NAME = logical_file_name , ]
FILENAME = 'os_file_name'
[ , SIZE = size ]
[ , MAXSIZE = { max_size | UNLIMITED } ]
[ , FILEGROWTH = growth_increment ] ) [ ,.... n ]
Description ::-
ON specifies the disk file used to store the data portion of the database.
LOG ON specifies the disk files used to store log files.
