RE: Another how to question

Susan: You're right, it sure ain't obvious. I am presuming you don't use fragmentation (mainly from your post the other day), so you can use the following: SELECT tabname, DBINFO('dbspace', partnum) AS dbsname FROM systables WHERE partnum > 0 AND tabid > 99 If you do use fragmentation, the query is much the same, but you need to look at the partn column of sysfragments for the part numbers. And of course, all of this is presuming you have version 7+. Hope that helps RET > ---------- > From: Susan Elliott (ISG) > Sent: Thursday, 27 August 1998 2:39 PM > To: 'Informix Mailing List' > Subject: Q: Another how to question > > Howdy folks, > > I have a simple need to know the tabname and what dbspace name it is > in... > > I have pored over the sys tables, and I haven't spotted anything that > will tell me this. Does anyone have a simple query that will tell me > this... or able to lead me in the right direction.... > > TIA > > Suze. >