---
title: "How to create a database in SSMS?"  
description: "How to create a database in SSMS?"  
author: "Revati S Misra"  
published: 2023-08-27  
updated: 2023-08-28  
canonical: https://www.mindstick.com/forum/159674/how-to-create-a-database-in-ssms  
category: "mssql server"  
tags: ["database", "sql server", "sql"]  
reading_time: 1 minute  

---

# How to create a database in SSMS?

How to create a [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax) in [SSMS](https://www.mindstick.com/forum/159672/what-are-the-benefits-of-ssms)?

## Replies

### Reply by Aryan Kumar

Sure, here are the steps on how to create a database in SSMS:

1. Open SSMS and connect to the SQL Server instance that you want to create the database on.
2. In the Object Explorer, right-click the **Databases** folder and select **New** > **Database**.
3. In the **New Database** dialog box, enter a name for the database.
4. Select the collation for the database.
5. Click **OK**.

The database will be created and will be displayed in the **Databases** folder.

Here are some additional details about the steps involved in creating a database in SSMS:

- The name of the database can be any valid SQL identifier.
- The collation is a set of rules that determines how character data is stored and compared.
- You can also specify other options for the database, such as the size of the database and the location of the data files.


---

Original Source: https://www.mindstick.com/forum/159674/how-to-create-a-database-in-ssms

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