Databases in Microsoft Sql Server are very crucial to help you store and manage your crucial data. As a developer, you will deal with the very basic task of creating a new database in your SQL server. In this article, I will walk you through all the possible approaches to create a new database in SQL Server.
How To Create A New Database In Microsoft Sql Server Management Studio
Let us discuss all possible approaches individually.
Approach-1 Using SQL Server Management Studio (SSMS)
To create a new database in Microsoft SQL Server Management Studio, follow the below steps.
1. Open SQL Server Management Studio (SSMS) and connect to your database server instance.
2. Right-click on the Databases folder and select the New Database option, as shown in the screenshot below.
3. Enter the new database name and then click on the OK button.
Now, expand the Databases folder, and you will see that the new database has been created successfully.
Check out How To Get The Connection String From SQL Server
Approach-2 Using SQL Query
We can execute the below CREATE DATABASE statement
CREATE DATABASE databasename;We can create a new database named DatabaseFAQs using the below query.
CREATE DATABASE DatabaseFAQs;After executing the above query, the new database was created successfully, as shown in the screenshot below.
Now, right-click on the Databases folder and select the Refresh option per the screenshot below.
You can see now that the new database has been created successfully. See the screenshot below for your reference.
Conclusion
Creating a new database in Microsoft Sql Server Management Studio is a basic task for a developer and SQL DBA. As mentioned in this article, one can use either the SSMS design approach or the CREATE DATABASE statement to create the database quickly.
You may also like following the articles below.
- How To Check Database Encryption In SQL Server
- How To Find Database Name In SQL Server
- SQL Server check user permissions on database
I am Bijay having more than 15 years of experience in the Software Industry. During this time, I have worked on MariaDB and used it in a lot of projects. Most of our readers are from the United States, Canada, United Kingdom, Australia, New Zealand, etc.
Want to learn MariaDB? Check out all the articles and tutorials that I wrote on MariaDB. Also, I am a Microsoft MVP.
