dbspace of where table is stored

Please, where I find "systable" where is this info stored? Thanks -- Jiří Lisický ČD KMŽP Olomouc e-mail: lisicky@datis.cdrail.cz Vídeňská 15 phone: +420-068-472-2272 Olomouc, Czech Republic >>> čeština ISO-8859-2 Compatible <<<

The tables are created in the dbspace where your database was created. But for fragmented tables and tables specifically created in specific dbspaces, the info is in sysfragments table. Use this sql: select b.tabname[1,18],a.dbspace[1,18] from sysfragments a, systables b where a.tabid = b.tabid and a.fragtype="T" order by 1,2 ; In article <oo301tcbjqdfu055ouu6oa4h4akc012q3q@4ax.com>, lisicky@datis.cdrail.cz wrote: > Please, where I find "systable" where is this info stored? > > Thanks > -- > Ji̩sick' Ȅ KM P Olomouc > e-mail: lisicky@datis.cdrail.cz V'''㫡 15 > phone: +420-068-472-2272 Olomouc, Czech Republic > >>> 襹tina ISO-8859-2 Compatible <<< > Sent via Deja.com http://www.deja.com/ Before you buy.