---
title: "How to create a database in a Microsoft SQL server?"  
description: "How to create a database in a Microsoft SQL server?"  
author: "Ethan Karla"  
published: 2021-09-14  
canonical: https://answers.mindstick.com/qa/93943/how-to-create-a-database-in-a-microsoft-sql-server  
category: "database"  
tags: ["database", "database management system"]  
reading_time: 2 minutes  

---

# How to create a database in a Microsoft SQL server?

How to create a [database](https://www.mindstick.com/articles/100/windows-service-to-update-record-from-one-database-to-another-after-certain-interval-of-time) in a [Microsoft SQL](https://www.mindstick.com/forum/159597/my-sql-server-vs-microsoft-sql-server-which-one-better) [server](https://www.mindstick.com/articles/43769/what-is-serverless-architecture-is-it-worth-switching-over) also write [query](https://www.mindstick.com/blog/202/sub-query-in-sqlserver)?

## Answers

### Answer by Ashutosh Kumar Verma

**Create Database in [SQL Server](https://www.mindstick.com/articles/12343/sql-server-2017-ctp-2-0-now-available) :**

There are generally two way to create a new Database in SQL Management Server, that is-

**1- By the use of SQL query** The SQL query which is use to create a new Database is as-

Syntax- CREATE DATABASE *database_name ;*

Ex- CREATE DATABASE Employees ;

![How to create a database in a Microsoft SQL server?](https://answers.mindstick.com/questionanswer/9e57bca3-adfd-4af0-ab1c-af1952c2cb36/images/cd6d4c61-86a3-49dc-841c-d12e9aea5bdb.png)

## 2- Create new Database using SQL Management Studio

To create a new Database in SQL server management studio firs you open SQL Server Management Studio in your Computer then go to 'Object Explorer'.

I- In Object Explorer select your server name and explore it then you have find Database Folder then Right Click on Database folder and Select 'New Database' option like as in following picture-

![How to create a database in a Microsoft SQL server?](https://answers.mindstick.com/questionanswer/9e57bca3-adfd-4af0-ab1c-af1952c2cb36/images/b350430d-920b-499a-a061-62a87d3e25a7.png) **\**

**II-** After click on 'NewDatabase' option a new window is appear on your Screen. Write your Database name as you have then click on 'OK'.

![How to create a database in a Microsoft SQL server?](https://answers.mindstick.com/questionanswer/9e57bca3-adfd-4af0-ab1c-af1952c2cb36/images/4ecb5a1d-4bda-4ef4-8fb5-1731a09b57e3.png)

III- You have find your database in Database folder of Object Explorer.

![How to create a database in a Microsoft SQL server?](https://answers.mindstick.com/questionanswer/9e57bca3-adfd-4af0-ab1c-af1952c2cb36/images/dc715219-0297-45be-a2de-71d51da9e6d4.png)

\

\


---

Original Source: https://answers.mindstick.com/qa/93943/how-to-create-a-database-in-a-microsoft-sql-server

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.