Creating a new SQL Server database

The procedure for creating a database depends on the version of the SQL Server client tools that you are using.

Using Microsoft SQL Server to create the database

1 Open SQL Server Management Studio.

2 In the Object Explorer pane, use the + symbol to expand the server on which you want to create the database.

3 Right click the Databases node and on the shortcut menu choose New Database. The New Database dialog opens.

4 In Database Name, enter a name for the database, for example, short_drinks.

5 Click OK. The database is created.

Requirements

Microsoft SQL Server Client Tools