Progress
SQL-92
Guide and Reference


SYSTABLES_FULL System Table

A superset of information in the SYSTABLES core system table.

Table B–25: 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


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095