syscolumns table

Posted in 2005

Topics: Stored Procedures & SPL, Data Types & Schema Design

tomcaml@gmail.com — 26 Aug 2005 09:38:26 -0700 — source: Usenet: comp.databases.informix

hello in each DB, there is a syscolumns table. one of the columns in that table is called "Coltype". can someone point me to where i would find the table that will tell me the actual column type. the coltype field in syscolumns displays a SMALLINT. thanks

↪ replying to tomcaml@gmail.com

June C. Hunt — Fri, 26 Aug 2005 12:59:26 -0400 — source: Usenet: comp.databases.informix

tomcaml@gmail.com wrote: > > in each DB, there is a syscolumns table. one of the columns in that > table is called "Coltype". can someone point me to where i would find > the table that will tell me the actual column type. the coltype field > in syscolumns displays a SMALLINT. thanks There is a chart in the IBM Informix Guide to SQL: Reference manual that will define the values in that column. I'm not aware of any table within the database that stores those definitions. HTH -- June Hunt