Steps to Create The Database & Table in SQL Server

Hello friends today we are going to see how we can create Database & Table in SQL Server :-

Here we are using SQL  Server Management Studio 2008:-




Step-1:-  Open SQL Server Management Studio 2008 .

Step-2 :-  After opening the SQL Server Management Studio  there will be a server name that is used to connect it with database Engine.

Step-3 :- After clicking connect  button , this window will open, Right click on Database. 

Step-4 :- After Right click on Database &  click on New Database.

Step-5 :- After clicking on new Database  make the Database by giving Database Name  & click                  ok .

Step-6 :- Click on  (+)  sign of database or expand it you will see a database is created.

  

Step-7 :- Now click (+) sign again on which database you have created you will get a table.

Step-8 :- Now right click on table & New Table.

Step-9 :-  Now give the table data when you give data it becomes column name of that table.

Step-9 :- Now save it with (ctrl+s) & give a name , you can save it by giving any name it's upon                  you.

Step-10 :- Now your table is created as you can see it on the  top of right side.