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

SYSCOLUMNS_FULL

A superset of information in the SYSCOLUMNS core system table.
The following table provides details of the SYSCOLUMNS_FULL table.
Table 12. 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
20
col_label
VARCHAR
60
col_label_sa
VARCHAR
12
col_subtype
INTEGER
4
description
VARCHAR
144
dflt_value
VARCHAR
250
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