Re: Q: PRIMARY KEY vs UNIQUE constraint

> What is the benefit in defining the structure of a table as a > PRIMARY-KEY vsa UNIQUE constraint in an Informix database? In other > words, (I have lookedin the manuals but could not find anything), how > does Informix treat thePRIMARY-KEY differently than a UNIQUE constraint? > They both use a uniqueindex and seem to be different only in the table > sysconstraint's constraint type (I forget the column name). > I think the only real difference is that a FOREIGN KEY can link to a PRIMARY KEY but not to a UNIQUE constraint. Malcolm Weallans Online Database Consultancy Phone 01628-72154 Fax 01628-37463 CIX - onlinedbc