Re: SQL to list Column names of a table

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

Check SYSCOLUMNS and SYSCOLUMNS2.

Eg.

SELECT *
    FROM syscolumns2
    WHERE system_table_schema = 'lib-name'
          AND system_table_name = 'table-name'
    ORDER BY system_column_name;

Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Cell: (416) 317-3144



On Fri, 15 Nov 2024 at 09:31, Mohan Eashver <mohankva@xxxxxxxxx> wrote:

> Happy Friday to you,
>
> Will you please tell me the name of the library and table that contains a
> data dictionary of all columns of all physical files in the system ?
>
> ----
> Regards,
> Mohan Eashver
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.