RE: dbspace and the table

Posted in 1999

Sadagopan, Sathish, CFCTR — Fri, 14 May 1999 09:37:19 -0400 — source: Informix-list mailing list archive (1991-1998)

select name dbspace_name, tabname table_name from systabnames t1, sysdbspaces t2 where trunc((hex(t1.partnum)/1048576)) = t2.dbsnum and tabname = "table_name_here" HTH Sathish Sadagopan -----Original Message----- From: John [mailto:jokarma@polbox.com] Sent: Friday, May 14, 1999 8:41 AM To: informix-list@iiug.org Subject: dbspace and the table How can I identify in which dbaspaces the table is located?