RE: How to get a list of objects in a db

I'm pretty sure this will give you what you want. select tabname, DBINFO('DBSPACE', a.partnum) from sysmaster:sysptnhdr a, systables b;JP -----Original Message----- From: David Gilbert [SMTP:xanadu@mcs.com] Sent: Thursday, August 28, 1997 1:27 PM To: informix-list Subject: How to get a list of objects in a dbspa Question: Is there a way, via 'sysmaster' to get a list of objects (tables and indexes) that exist in a dbspace using just a SELECT statement? I can get most of the information from 'systabnames', but I can't find a way to tell what type the object is. I could go into each database, but that would be a pain. To summarize: SELECT .... FROM .... WHERE dbspace = 'my_data' ... would return: database, owner, name, type Any ideas? Thanks in advance! -- David Gilbert (xanadu@mcs.net) WEB: http://www.mcs.net/~xanadu ------ Message Header Follows ------ Received: from mh1.panasonic.com by mecamail.panasonic.com (PostalUnion/SMTP(tm) v2.1.8d for Windows NT(tm)) id AA-1997Aug28.111504.1486.682037; Thu, 28 Aug 1997 11:15:05 -0400 Received: from gatekeeper.panasonic.com (mecanet.panasonic.com [140.212.2.65]) by PANASONIC-MAILHUB1 with SMTP id LAA19250; Thu, 28 Aug 1997 11:16:09 -0400 Received: from rmy.rmy.emory.edu by gatekeeper.panasonic.com (AIX 4.1/UCB 5.64/Xinu) id AA24014; Thu, 28 Aug 1997 10:49:15 -0400 Received: (from ilist@localhost) by rmy.rmy.emory.edu (8.7.1/8.7.1) id KAA03801 for informix-list-out; Thu, 28 Aug 1997 10:55:01 -0400 (EDT) From: xanadu@mcs.com (David Gilbert) Message-Id: <5u40cd$ork$1@Mars.mcs.net> Subject: How to get a list of objects in a dbspace via SQL? Date: 28 Aug 1997 09:01:49 -0500 Reply-To: xanadu@mcs.com (David Gilbert) Organization: /usr/lib/news/organi[sz]ation Sender: informix-list-owner@rmy.emory.edu To: informix-list@rmy.emory.edu X-Informix-List-Id: <news.42232>