How to Create Table on SQL Server ~ Codes-47

Here the Following steps on how to create Table on your
SQL Server 2005

On your Database that you Created just click the cross
box to view it on a hierarchical form shown on the image
below, by creating database just follow this link
How to Create a Database on SQL Server 2005,
then on the Tables just simply right-click and press
New Table

After pressing New Tables this will prompt to you or also
known as the Design View, Insert your Column Name,
and Specified the Data Types,and Allowing Nulls if you
want to not Duplicate the Value of the data or the value of
ID_Num to avoid Data Redundancy just unchecked the
box,or you want to duplicate it just leave it with checked

Then Click Save and prompting the Choose Name Dialog
so choose your table name at this time i type Employees

Then you can see your table under Tables,just click the cross box
it will show the dbo.Employees,it will show also at the summary at the
right pane of object explorer

or we can also create table via SQL Query by doing this
just press New Query Tab, then enter this following code

--this will create also the Employees table

CREATE TABLE Employees (

     ID_Num int NOT NULL,
     First_Name varchar (25),
   Last_Name varchar(50),
    Middle_Name varchar(50),

)

Good Luck (^_^)

These icons link to social bookmarking sites where readers can share and discover new web pages.