Diference between unique key and primary key

praneethgokul · New User Joined: 06 May 2005 Posts: 20 Location: Bangalore

Hi all,

I got 2 silly doubts on primary key.

1. What happens to data when we disable primary key on data?

2. What is diference between unique key and primary key?

Thanks in advance.

chayanath · New User Joined: 07 Mar 2005 Posts: 6 Location: vijayawda

hello,

1. I am not sure that word disble do exists interms of a data in table

2. There can be only one primary key for a table
and multiple unique keys.

i hope this can do it for u.

bye
chayanath

sudheer648

Hi Praneeth,

Answering Your Quetions

1.Disable the Primary key -- am Not pretty sure you can disable the primary key.

2.Difference btn Primary Key and Unique Key is
Primary Key is Unique and NotNull --The values should be unique and should not be Null.
UniqueKey --The Values should be Unique and can be null even

jkbytes

Sudheer wrote:

sudheer648

Hi Bytes,

Only one Null is accepted not the second obviously.it will also treated as an value.

Cheers,
Sudheer