On 11 Mar 2005 20:40:15 -0800, Ariji Chatterjee wrote:
> Dear Faculties,
> Here I have created a table in two manner ..
> ===================================
In first scenario you have created a unique key, but it's not the primary,
therefore the engine would still let you create an actual PK on that table
while in the second scenario it would not. Of course both scenarios would
lead to failure of an attempt to insert duplicate data in the table. You
can have as many unique indexes as you like in a table but only one PK.
Received on Sat Mar 12 2005 - 07:13:19 CST
