Re: diff. between Primary-Key and unique index

the only difference between a column being declared as a primary key or as a unique key is that if the column is a primary key one cant insert null values in that column (in any record) where as if a column is declared as a unique key it will allow null value in that column (but only once) since the column is unique and therefore null values can occur but only once

Regards
~Parvinder

Andreas Michler wrote:

> Can anyone tell me the differences between a table with primary key
> and
> a table with no primary key, but a unique index on some fields
> ????????
>
> -------------------------------------
> ADICOM Informatik GmbH
> Andreas Michler
> Wiesfleckenstr. 34
> 72336 Balingen
> Tel: 07433/9977-57,Fax: -90
> E-Mail: Andreas.Michler_at_adicom.de
> http:\\www.adicom.de
> -------------------------------------
Received on Fri Jan 21 2000 - 09:07:14 CST