set up constraints on informix table
set up constraints on informix table
(OP)
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
The table is called STSTY and I need one constraint on field styleid, no duplicates allowed.
Many thanks
Michelle
RE: set up constraints on informix table
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