Progress
SQL-92
Guide and Reference


SYSDATATYPES System Table

Contains information on each data type supported by the database.

Table B–10: 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 © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095