Re: Finding dbs for table

Mark D. Stock wrote: > > Bill Ennis wrote: > > > > With fragmentation a table can belong to more than one dbspace. > > I belive the first 3 chars in partnum contain the dbspace number > > for the table. You can view partnum in the systables table. > > My guess is that if you do fragment a table you will have multiple > > systables entries for those tables. > > Not quite. The partnum will be NULL, and you will get one record in > sysfragments for each fragment. These records have the fragment partnum. But he did not ask where to find his tables but where to find the database itself. See my previous. You could do the same thing by table from systables for non-fragmented tables and sysfragments for fragmented tables. Art S. Kagel