Progress
SQL-92
Guide and Reference


SYSCOLUMNS Core SystemTable

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

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