Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2002
    Location
    Ireland
    Posts
    12

    Unanswered: Table Column information

    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

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    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
    ***********************************************

  3. #3
    Join Date
    Jun 2002
    Location
    Ireland
    Posts
    12
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •