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

SYSTABLES_FULL

A superset of information in the SYSTABLES core system table.
The following table provides details of the SYSTABLES_FULL table.
Table 29. SYSTABLES_FULL system table
Column name
Column data type
Column size
can_dump
VARCHAR
126
can_load
VARCHAR
126
creator
VARCHAR
32
description
VARCHAR
144
dump_name
VARCHAR
16
file_label
VARCHAR
60
file_label_sa
VARCHAR
12
frozen
BIT
1
has_ccnstrs
VARCHAR
1
has_fcnstrs
VARCHAR
1
has_pcnstrs
VARCHAR
1
has_ucnstrs
VARCHAR
1
hidden
BIT
1
id
INTEGER
4
last_change
INTEGER
4
owner
VARCHAR
32
prime_index
INTEGER
4
rssid
INTEGER
4
segid
INTEGER
4
tbl
VARCHAR
32
tbltype
VARCHAR
1
tbl_status
VARCHAR
1
user_misc
VARCHAR
20
valexp
VARCHAR
144
valmsg
VARCHAR
144
valmsg_sa
VARCHAR
12