Create a database by specifying the mdf file : Create Database « Database « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Database
  3. Create Database
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








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.