Re: List tables in dbspace through sysmaster query
Here it is.....
select s2.name,s1.tabname,s1.owner from systabnames s1,sysdbspaces s2
where s2.dbsnum=trunc(s1.partnum/1048576)
order by name,tabname,owner
Vinod Bhansali
>From: Jeff Christen <jrc42@cornell.edu>
>To: informix-list@iiug.org
>Subject: List tables in dbspace through sysmaster query
>Date: Thu, 18 May 2000 14:31:09 -0400
>
>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.
>
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com