> -----Original Message-----
> From: Dmitry Yemanov [mailto:dimitr@...]
> Sent: Monday, July 17, 2006 10:38 AM
>
> "Bob Murdoch" <mailgroups@...> wrote:
> >
> > Index 4 is corrupt on page 3853736 in table XRDS501 (303)
> >
> > From previous experience, I know that I can alter the index
> > inactive/active to rebuild it. However, how do I know exactly

which

> > index is "Index 4"?
>
> select RDB$INDEX_NAME
> from RDB$INDICES
> where RDB$RELATION_NAME = 'XRDS501' and RDB$INDEX_ID = 4

Thanks Dmitry.

What if the index is the primary key? Can I alter inactive/active?

thanks,

Bob M..