A CREATE DATABASE Example : Create Database « Database « SQL Server / T-SQL Tutorial

a complete example of the CREATE DATABASE command, 
specifying three files and all the properties of each file:

CREATE DATABASE Archive
ON
PRIMARY
( NAME = Arch1,
FILENAME = 'c:\archdat1.mdf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20),
( NAME = Arch2,
FILENAME = 'c:\archdat2.ndf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20)
LOG ON
( NAME = Archlog1,
FILENAME =
    'c:\archlog1.ldf',
SIZE = 100MB,
MAXSIZE = 200,
FILEGROWTH = 20)

19.1.Create Database
	19.1.1.	Creation of a Database
	19.1.2.	A CREATE DATABASE Example
	19.1.3.	create and drop database
	19.1.4.	If a database exists
	19.1.5.	A statement that attaches an existing database file
	19.1.6.	Create a database by specifying the mdf file
	19.1.7.	Create a database by indicating the mdf file
	19.1.8.	Attach a mdf file to database
	19.1.9.	Creates a database with explicit specifications for database and transaction log files.