How to create Database in SQL Management Studio

In this section I will show you how to create Database in SQL Management Studio

1-      Open SQL Management Studio

2-      Go to Object Explorer (View à Object Explorer)

3-      Right Click on the Databases and click on New Database…

                    

4-      You will get the New Database Window. In the General Section write the name of the database in the Database name:

Here I have given TestDB.

5-      You can change the physical location of the database by clicking on the button in the path column of Database files

By default it is C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\

6-      Click on OK button

 

7-      The TestDB Database appears in the Databases in the Object Explorer