SQL Server/T-SQL/Database/Create Database

Create a database: simplest statement

   <source lang="sql">

1> CREATE DATABASE myDatabase; 2> GO 1> 2> Drop database myDatabase; 3> GO 1>

      </source>
   
  

Create database by setting the mdf file, size, maxsize and file growth rate

   <source lang="sql">

1> CREATE DATABASE Database_2 2> ON PRIMARY 3> (NAME = Database_2_dat, 4> FILENAME = "c:\dat.mdf", 5> SIZE = 2MB, 6> MAXSIZE = 20, 7> FILEGROWTH = 10%) 8> LOG ON 9> (NAME = Database_2_log, 10> FILENAME = "c:\log.ldf", 11> SIZE = 4MB, 12> MAXSIZE = 10MB, 13> FILEGROWTH = 20%) 14> GO 1> 2> -- EXEC sp_helpdb Database_2 3> GO 1> DROP DATABASE Database_2 2> GO 1>

      </source>
   
  

Create database from mdf file

   <source lang="sql">

CREATE DATABASE your_database_name ON PRIMARY (FILENAME = "C:\dat.mdf") FOR ATTACH GO drop database your_database_name GO

      </source>