Systables partnumber

Posted in 2005

vasilis.economides@ctl.com — 16 Nov 2005 07:30:23 -0800 — source: Usenet: comp.databases.informix

Hi, I have informix 9.30.TC1 on Win2000. The partnumber of some tables is 0. What does this mean? Other tables have partnumber such as 5243168. Thanks, Vasilis

↪ replying to vasilis.economides@ctl.com

bozon — 16 Nov 2005 12:05:49 -0800 — source: Usenet: comp.databases.informix

They are views which aren't stored in the database. dbschema -d <database> -t <tablename> Will show you the SQL that created the view.