Re: Tables in dbspaces
SteveS wrote:
>
> Is there a way to list all of the tables that are in a dbspace?
What version?
Off the top of my head, something like:
SELECT tabname
FROM systables
WHERE tabid > 99
AND tabtype = "T"
AND DBINFO('DBSPACE', partnum) = "mydbspacename"
will work in version 7.x.
Hope that helps,
--
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 11 807 2594 |If it's fast, the users keep quiet.|// / /////|
|Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////|
+----------------------+-----------------------------------+-----------+