Primary and Foreign key using table.

use chitharans
create table NewBusiness1
(
businessid int identity(2010,10) not null,
businessname varchar(20) not null,
companyname varchar(20) not null,
startingdate datetime not null,
endingdate datetime not null

CONSTRAINT [PK_ NewBusiness1] PRIMARY KEY CLUSTERED
(
    [businessid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO