Re: tables in dbspace

Posted in 1999

Mark D. Stock — Tue, 02 Mar 1999 10:03:10 +0200 — source: Informix-list mailing list archive (1991-1998)

Sujit.Pal@BankAmerica.com wrote: > > David > > How about: > > SELECT DBINFO('dbspace', HEX(partnum)), tabname > FROM systables > WHERE tabid > 99 > GROUP BY 1;,2 > ORDER BY 1,2; NOTE: That would rely on you knowing which databases store tables in the specific dbspaces. > 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? Cheers, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 838250 2325 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+