|Subject||Re: [ib-support] Unique constraint not an index? was Re: Error:Object is in use|
> > > >Are You sure?IB_WISQL
> > > >I created the table with a unique constraint and if I look with
> > > >it shows meor...Ann?
> > > >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
> > >Yes, I read her notice about that a unique constraint is the same as an
> > > 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.
> >Jörg Schiemann
> Did you notice Ann's reply...?
Sorry for the wasted bandwidth, but I thougt you want to see the result.
Thanks for your help.