Database MSSQL Tutorial

4>    IF NOT EXISTS ( SELECT 'True' FROM INFORMATION_SCHEMA.SCHEMATA  WHERE
5>       CATALOG_NAME = 'NorthwindCreate')
6>    BEGIN
7>       CREATE DATABASE NorthwindCreate
8>       ON
9>       ( NAME = NorthwindCreate,
10>         FILENAME = 'c:\NorthwindCreate.mdf' )
11>    END
12>    ELSE
13>    BEGIN
14>       PRINT 'Database already exists. Skipping CREATE DATABASE Statement'
15>    END
16>    GO