Re: which tables are in a specific dbspace?

Papp Gabor 27 Aug 99, 9:35: > Hello! > > How can I get, which tables are in a specific dbspace? > > thanks > Gabor > > Use the above sql: select dbinfo("dbspace",partnum) location, tabname from systables where partnum is not null and tabid > 99 -- and tabname = "table_name" Uncomment this line for a spacefic table union select dbinfo("dbspace",partn) location, t.tabname from sysfragments f, systables t where t.tabid > 99 and f.tabid = t.tabid and f.fragtipe="T" -- and tabname = "table_name" PS. I supose you work with IDS Ver. 7.2x or later. --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes de Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------