How to get a list of objects in a dbspace via SQL?

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