Hi Lynin,

Thank u very much for ur quick reply,

i want different primary keys for fname and lname,

here my requirement is :

FK- FName should be FK of Users.FName

FK- LName should be...

Hi Stewart,

It is working, Thanks for ur quick reply.

Thank's

Sandeep.

Thank you very much i gain good knowledge with support of you.

Hi Sam,

i did a mistake there,

first i created clustered Index on eno column

again now i'm trying to add the pk on eno column that is the reason it's...

Hi Sam,

table doesn't have any null value.

i have used below code,

alter table index1

alter column eno int not null

go

alter table index1

add constraint xafd_314 primary key (eno)

Thank's

Sandeep.

Hi SAM,

Thank you for your quick reply,

even that table not allowing to add not null constraint,

here eno column having five rows of data .

Thank's

Sandeep

Thank u my dear it is working.

Thank's

Sandeep