How to create database in SQL server?

 In this article, we will discuss two ways of creating database in SQL Server.

1) from GUI (graphical user interface)

2) from query 

1) GUI method

First of all, right click on databases as shown in figure and then option pops up. Click on "New Database" as shown below.

A new window is seen now as shown below:

Provide Name of database and then click OK. 

Now, your new database is created.

2) Using query

Click in "New Query". A new query analyzer will be displayed.

Type the following query in query analyzer

CREATE DATABASE YourDatabaseName;

Click Execute (or press F5) to run the query. Database will be created.