Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : OpenEdge SQL System Catalog Tables : SYSDATATYPES
 

SYSDATATYPES

Contains information on each data type supported by the database.
The following table 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