Re: tables in dbspace

Posted in 1999

Sujit.Pal@BankAmerica.com — Mon, 01 Mar 1999 08:29:58 -0800 — source: Informix-list mailing list archive (1991-1998)

David How about: SELECT DBINFO('dbspace', HEX(partnum)), tabname FROM systables WHERE tabid > 99 GROUP BY 1;,2 ORDER BY 1,2; HTH Sujit David Grove <david_grove@health.state.ak.us> on 02/26/99 12:57:09 PM Please respond to David Grove <david_grove@health.state.ak.us> To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: tables in dbspace Folks, Might someone suggest a way to derive a list of all tables that exist in each dbspace? Thank you for any comments. David Grove Dept. Health & Social Svcs. State of Alaska