A

> > >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

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________