Microsoft SQL Server 2014 Unleashed

Using T-SQL to Create Databases

Instead of using SSMS, you can use T-SQL to create a database. The T-SQL command to do this is CREATE DATABASE. The CREATE DATABASE syntax is extensive and is best illustrated with an example. Listing 20.1 shows a sample script to create a database called mydb. This script was generated using the Script option available on the New Database screen.

LISTING 20.1 Using T-SQL to Create a Database

Click here to view code image

CREATE DATABASE [mydb] ON  PRIMARY( NAME = N'mydb', FILENAME = N'C:\mssql\data\mydb.mdf' ,     SIZE = 2048KB , FILEGROWTH = 1024KB ) LOG ON( NAME = N'mydb_log', FILENAME = N'C:\mssql\log\mydb_log.ldf',     SIZE = 1024KB , FILEGROWTH = 10%)GO

The database created in Listing 20.1 is relatively ...