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.