Re: Tabnames

> >anyone idea, how to retrieve the names of the tables for specific > ><db_name>? > >I ran : > > > >database sysmaster; > >select tabname from systabnames where dbsname=<db_name>;> > > >but I got the names of the indexes too. > > Oh? I tried this for several databases and I couldn't repeat that behaviour. > FWIW. Did you have any detached or fragmented indexes in these databases that you tested with? Basically, it looks like systabnames tracks anything with its own partition number. Each detached index has its own partition number, as well as each fragment of an index or table. This means that the you will get multiple entries with the same tabname for fragmented objects. Mark Collins mcollins@us.dhl.com Dilbert is a documentary.