RE: primary and unique index

Informix Guide to SQL Syntax Page 2-44: n When you place a primary-key or unique constraint on a column or set of columns, and a unique index already exists on that column or set of columns, the constraint shares the index. However, if the existing index allows duplicates, the database server returns an error. You must then drop the existing index before you add the constraint. So, in essence it is 6 of the 1, and half-a-dozen of the other. My recommendation would be to drop the unique index to make the database schema less confusing. > -----Original Message----- > From: samir BADAOUI [SMTP:samir_badaoui@hotmail.com] > Sent: Wednesday, September 29, 1999 11:26 AM > To: informix-list@iiug.org > Subject: primary and unique index > > hi all, > in my database, I have a primary key with columns (a,b,c) and a unique > index > with columns (a,b,c). I think that the primary key is enough and i can > drop > the unique key. Wath do you think ??. > i can't drop the primaru key because it serves in the references > constraints. > > thanks for help. > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.com