Saturday, September 27, 2014

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