Re: List of Tables in a DBspace?

murphy@tc.pw.com (Jay Murphy) wrote: :Hello, :I apologize if this is a simple question... but it's been puzzling me :for quite a bit. I'm interested in obtaining a list of tables :contained in a particular DBspace. Is this possible either through :querying the SMI tables or using an Informix provided utility such as :onstat (with an option that's not apparent to me)? I'm using the :On-line product version 7.xx. Any help would be greatly appreciated. :I can be reached at murphy@tc.pw.com. Yes, using dbschema -d databasename -ss you get a list of all tables including information on the dbspace. You can make a list from the SMI tables also. I seem to remember something about some partno column to find the dbspace. If it's important to you you should be able to find the needed info in the manuals. Otherwise I am sure someone else will jump in with the info on this. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company