Progress
SQL-92
Guide and Reference


SYSCOLUMNS_FULL System Table

A superset of information in the SYSCOLUMNS core system table.

Table B–9: 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
10
col_label
VARCHAR
60
col_label_sa
VARCHAR
12
col_subtype
INTEGER
4
description
VARCHAR
144
dflt_value
VARCHAR
323
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 © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095