Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## SYSDATATYPES

> Contains information on each data type supported by the database.

> Table 13 provides details of the SYSDATATYPES table.

> Table 13: SYSDATATYPES system table
> Column name | Column data type | Column size
> --- | --- | ---
> autoincr | SMALLINT | 2
> casesensitive | SMALLINT | 2
> createparams | VARCHAR | 32
> datatype | SMALLINT | 2
> dhtypename | VARCHAR | 32
> literalprefix | VARCHAR | 1
> literalsuffix | VARCHAR | 1
> localtypename | VARCHAR | 1
> nullable | SMALLINT | 2
> odbcmoney | SMALLINT | 2
> searchable | SMALLINT | 2
> typeprecision | INTEGER | 4
> unsignedattr | SMALLINT | 2

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