CREATE - SQL - Database

Using SQL Server Management Studio:

The SQL Server Management studio (SSMS) is a platform used for managing and administering SQL server instances and databases. It allows database administrators, developers, and users to connect to SQL Server instances and perform various tasks such as creating, modifying, and deleting tables, views, store procedures, and other database objects.

Following are steps to create a database using the SQL Server Management Studio −

Step 1− Open the SQL Server Management Studio in your system and connect to the SQL Server instance where you want to create the database.

Step 2− In the Object Explorer, right click on the “Databases” option and click on the “New Database”.


Step 3− A “New Database” dialog box will be opened.

Step 4− Enter a name for the new database that you want to create in the “Database name field”.

Step 5− To create the database with default values, click “OK”; otherwise, continue with the following optional steps.

Step 6− If you want to specify a different owner for the database, click on the “…” button next to the “Owner” fiels and select a different owner.

Step 7− If you want to change the default values of the primary data and transaction log files in the “Database files” grid, select the particular cell and enter the new value.

Step 8− If you want to change the collation of the database, select the options page on the top-left corner and then select a collation from the list.

Step 9− If you want to change the recovery model of the database, select the options page and then select a recovery model from the list.

Step 10− If you want to change the database options, select the options page and then modify the database options.

Step 11− If you want to add a filegroup, select the “Filegroups” page on the top-left corner. Then Select “Add Filegroup” and then enter the values for the file group.

Step 12− Now, click on “OK” to create the database.