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

SYSCOLUMNS

Contains one row for each column of every table in the database.
The following table provides details of the SYSCOLUMNS table.
Table 6. 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