Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How do you create a new database in SQL Server?

Utpal Vishwas 717 16 May 2023

How do you create a new database in SQL Server?

1 Answers

Aryan Kumar 16 May 2023

There are two ways to create a new database in SQL Server:

Using SQL Server Management Studio (SSMS):

Open SQL Server Management Studio.
Expand the Databases node.
Right-click the Databases node and select New Database.
In the New Database dialog box, enter a name for the database.
Select a location for the database.
Select the database file size.
Click OK to create the database.

Using the CREATE DATABASE statement:

Open a query window in SQL Server Management Studio.
Type the following:

Code snippet

CREATE DATABASE database_name

Replace database_name with the name of the database.
Press F5 to execute the statement.

The database will be created in the default location and with the default file size.

Here are some additional things to keep in mind when creating a new database:

The name of the database must be unique within the instance of SQL Server.
The location of the database can be on the local computer or on a network share.
The file size of the database can be changed later.

Once you have created a new database, you can start creating tables, views, stored procedures, and other objects.

advertising

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.