what is the difference in this..
we have a table which has one primary key and one unique key with not
null constraint..
so r they equal...
--
You received this message because you are subscribed to the Google Groups
Algorithm Geeks group.
To post to this group, send email to
There can be any # candidate keys but only one primary key in a table..
every candidate key can give u unique row in that table
deciding which key should be the primary depends on some parameters like ..
--length of the key ..
--# of attributes in that key ..
--frequency of using that key for
Hi,
Unique key with not null constraint works similar to the Primary key. Both
will uniquely identify each row of the table with not null constraint.
The only difference is a table may have arbitrarily many unique keys but at
most one primary key.
--
Kind Regards
Ishan Aggarwal
[image: