Re: List tables in dbspace through sysmaster query

---- you wrote: > This would not list any tables which are fragmented by "round robin", > "expression" because systables has it's partnum as zero. Of course it does Dude! Why didn't you read my answer, before attempting to shoot it down in flames? It doesn't even mention systables. That would be silly as the question was about a select on sysmaster! > ---- you wrote: > > Hi, > > > > I'm trying to find a way to list the tables located in a dbspace through a > > query > > against the sysmaster db. I'm sure it's possible, but I can't find a table > > in sysmaster > > containing the table to dbspace mapping. Anyone know how to list the > > tables in a specific > > dbspace through a query against the sysmaster database? > > > > Thanks, > > > > Jeff > > > > P.S. I am using informix 7.31UC5, I'm not sure if it matters. > > You can use this Dude: > > select dbsname, tabname > from systabnames > where dbinfo("dbspace", partnum) = "rootdbs"> > AB > ---------------------------------------------------------------- > Get your free email from AltaVista at http://altavista.iname.com > AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com