[tlohan]

Hi,

In DBACCESS I can go into Info and get a description of the table columns and their type:

Column name Type Nulls

group_id serial no
state smallint yes
lastupdate int8 yes
updaterate smallfloat yes
tc_id integer yes
ident_object_id varchar(255) yes

I want to run a SQL statement against the database to pull out certain column names and their types but I do not know what table this information is gathered from.

Is it in the sysmaster database ??

Can anyone point me in the right direction ?

Thanks,

Tom

[eherber]

The type of a column is coded in 'syscolumns.coltype'.

But you will not be able to write a query to get this
information in really readable format. It's not that easy.
You have to decode the values from 'syscolumns.coltype".

An Esql/C program or stored procedure might be a possible
solution.
The values of 'syscolumns.coltype' should be somewhere
described in the IFMX manual.

HTH.

Best regards

Eric
--
IT-Consulting Herber
WWW: http://www.herber-consulting.de
Email: eric@herber-consulting.de

***********************************************
Download the IFMX Database-Monitor for free at:
http://www.herber-consulting.de/BusyBee
***********************************************

[tlohan]

Hi,

I've been able to solve the problem using DBSCHEMA.

The command

dbschema -d performance_database -t table_name -ss

can be used to pipe the SQL for the table out to a file.

Cheers,

Tom