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

• Using SQL Server Management Studio (SSMS):

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

• Using the CREATE DATABASE statement:

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

Code snippet

CREATE DATABASE database_name

1. Replace database_name with the name of the database.
2. 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.