Skip to main content
Learning DUB

How to Create an SQL Server Database

1. In a Query Editor window, type but do not execute the following code: CREATE DATABASE TestData GO 2. Use the pointer to select the words CREATE DATABASE, and then press F1. The CREATE DATABASE topic in SQL Server Books Online should open. You can use this technique to find the complete syntax for CREATE DATABASE and for the other statements that are used in this tutorial. 3. In Query Editor, press F5 to execute the statement and create a database named TestData. When you create a database, SQL Server makes a copy of the model database, and renames the copy to the database name. This operation should only take several seconds, unless you specify a large initial size of the database as an optional parameter. The keyword GO separates statements when more than one statement is submitted in a single batch. GO is optional when the batch contains only one statement.

Keep in Mind:

//////////////End Copy Code ////////////////
Breakdown of your Risk Level

Related Content

Scroll to Top