set up constraints on informix table

MichelleButler · Apr 10, 2002

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 · Apr 10, 2002

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

set up constraints on informix table

MichelleButler

IS-IT--Management

olded

Programmer

Similar threads

Part and Inventory Search

Sponsor