Re: Error in creating table. (Newbie)

tonytd@ttyrwhit.demon.co.uk (Tony Tyrwhitt-Drake) wrote: >When you specify -unique- against a field in your schema, Informix >very kindly creates an unique index for you. Thus if / when you >later try to create a unique index on the same field you get the >duplicate key message. >The way around this, is either do not use the -unique- against >the field, but create your own index, or bung in the -unique- >and enjoy the automatically created index 8-> I follow that, and thank you for the information, and the others who helped via email. However, my second question is still unanswerd: What if you have multiple candidate keys and put the "NOT NULL UNIQUE" constraint on each?