Mega Code Archive

 

Categories / MSSQL Tutorial / Database

 

Create a database by specifying the mdf file

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