Tracing an index back to its table

ingres@PROBLEM_WITH_INEWS_GATEWAY_FILE (Administrador de Ingres) writes:
> 
> 	I have a very big problem with my database. I have a index and 
> i don't know  its table. How can i know it ?
> 
> 	My version of ingres is 6.4/04
> 

select r2.relid

from iirelation r1,
     iirelation r2

where r1.relid = 'index_name'
and   r1.reltid = r2.reltid
and   r2.reltidx = 0

(I think ! I'm at home, it's late, etc, etc)

-- 
Graham Parsons
Principal Consultant
Forest Consulting Limited

Ingres Q & A

To William's Home Page

Email William