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