Re: List tables in dbspace through sysmaster query

---- 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