Jesoba.com is launched, Click below image to access it

Jesoba.com is launched, Click below image to access it
Technology and Entertainment Blog

How to create table in SQL Server Database

Title : How to create table in SQL Server Database.

Article ID : SS0001

Description : To way to create table in SQL Server.

1.
      Type this query in New query tab in tab group and select it clik on Execute button or press F5.
-----This query will create table in  below given database--------

USE EMPLOYEE
create table emp
(


 Idemp BIGINT Constraint pk Primary Key ,
 userid VARCHAR(10),
 userpassword VARCHAR(8),
 usercontact VARCHAR(10)
)

----------------------------------------------------------------------------- 
2.
Goto : Object Explorer ---> Select your Database ---> Select Tables.
           Now Right Click on Tables and Select "New Table..." Option.
           It display "Table-dbo.Table1" Tab in tab group. As below .....
           Click on Images :



   
            Now enter table column and make table Id as Primary Key.
            as shown in below Image.

                         

Image/Video : N/A

Keyword : SQL Server table ,Create Table, Way of Create Table in Database.

Reference : N/A

No comments:

Google+ Badge

About Author

My photo

I am Senior Server Expert and Professional Blogger.