> > > >Are You sure?
> > > >I created the table with a unique constraint and if I look with

IB_WISQL

> > > >it shows me
> > > >an unique index on ORDER_ID, ORDER_POS
> > > >and an index on ORDER_ID
> > >
> > > This could be an anomaly in IB_WISQL or a bug introduced by IB 6

or...Ann?

> > >
> > > Try checking the output of this query:
> > >
> > > select rdb$index_name, rdb$relation_name from rdb$indices
> > > where rdb$relation_name = 'PARTS'
> >
> >RDB$INDEX_NAME RDB$RELATION_NAME
> >=============================== ===================
> >
> >RDB$PRIMARY21 PARTS
> >RDB$FOREIGN22 PARTS
> >RDB$23 PARTS
> >IDX_DRAFT_NO PARTS
> >
> >RDB$23 is the unique constraint.
> >
> >Regards,
> >Jörg Schiemann
>
>
> Did you notice Ann's reply...?
>
> Helen

Yes, I read her notice about that a unique constraint is the same as an
unique index.
Sorry for the wasted bandwidth, but I thougt you want to see the result.

Thanks for your help.
Jörg