Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## SYSCOLUMNS

> Contains one row for each column of every table in the database.

> Table 6 provides details of the SYSCOLUMNS table.

> Table 6: SYSCOLUMNS core system table
> Column name | Column data type | Column size
> --- | --- | ---
> charset | VARCHAR | 32
> col | VARCHAR | 32
> collation | VARCHAR | 32
> coltype | VARCHAR | 10
> dflt_value | VARCHAR | 250
> id | INTEGER | 4
> nullflag | VARCHAR | 1
> owner | VARCHAR | 32
> scale | INTEGER | 4
> tbl | VARCHAR | 32
> width | INTEGER | 4

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095