set up constraints on informix table

[MichelleButler]

Please could anybody help me, I would like to set up a constraint on a table where only one field is unique but I am unable to remember the SQL query. Can anybody help?

The table is called STSTY and I need one constraint on field styleid, no duplicates allowed.

Many thanks

Michelle

 

[olded]

Michelle:

If I'm interpreting correctly what you want:

create unique index myindexname on ststy(styleid);

you'll probably want choose your own indexname.

Regards,

Ed
Schaefer