Re: Tables in dbspaces

Posted in 1998

Sujit.Pal@alltel.com — Fri, 16 Oct 1998 09:51:33 -0700 — source: Informix-list mailing list archive (1991-1998)

Steve This SQL will do it for you: select tabname, dbinfo('dbspace', hex(partnum)) spacename from systables where tabid > 99 and dbinfo('dbspace',hex(partnum)) = "your_dbspace_name" HTH Sujit ______________________________ Reply Separator _________________________________ Subject: Tables in dbspaces Author: "SteveS" <ssilva@prestongates.com> at Internet Date: 10/15/1998 1:27 PM Is there a way to list all of the tables that are in a dbspace? Thanks in advance. Steve