Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## SYSCOLUMNS_FULL

> A superset of information in the SYSCOLUMNS core system table.

> Table 12 provides details of the SYSCOLUMNS_FULL table.

> Table 12: SYSCOLUMNS_FULL system table
> Column name | Column data type | Column size
> --- | --- | ---
> array_extent | INTEGER | 4
> charset | VARCHAR | 32
> col | VARCHAR | 32
> collation | VARCHAR | 32
> coltype | VARCHAR | 20
> col_label | VARCHAR | 60
> col_label_sa | VARCHAR | 12
> col_subtype | INTEGER | 4
> description | VARCHAR | 144
> dflt_value | VARCHAR | 250
> dflt_value_sa | VARCHAR | 12
> display_order | INTEGER | 4
> field_rpos | INTEGER | 4
> format | VARCHAR | 60
> format_sa | VARCHAR | 12
> help | VARCHAR | 126
> help_sa | VARCHAR | 12
> id | VARCHAR | 4
> label | VARCHAR | 60
> label_sa | VARCHAR | 12
> nullflag | CHARACTER | 2
> owner | VARCHAR | 32
> scale | INTEGER | 4
> tbl | VARCHAR | 32
> user_misc | VARCHAR | 20
> valexp | VARCHAR | 144
> valmsg | VARCHAR | 144
> valmsg_sa | VARCHAR | 12
> view_as | VARCHAR | 100
> width | INTEGER | 4

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