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

SYSTABLES

Contains one row for each table in the database.
The following table provides details of the SYSTABLES table.
Table 5. SYSTABLES core system table
Column name
Column data type
Column size
creator
VARCHAR
32
has_ccnstrs
VARCHAR
1
has_fcnstrs
VARCHAR
1
has_pcnstrs
VARCHAR
1
has_ucnstrs
VARCHAR
1
id
INTEGER
4
owner
VARCHAR
32
rssid
INTEGER
4
segid
INTEGER
4
tbl
VARCHAR
32
tbl_status
VARCHAR
1
tbltype
VARCHAR
1