Table
Property keys mapped to the columns of the OpenEdge SQL `SYSTABLES` system catalog table.
SYSTABLES contains one row for every table, view and system table that is
defined in the database.
Tags
Table of Contents
Constants
- COLUMNS : string = 'columns'
- Collection of columns owned by this table (denormalized convenience key).
- NUMBER_OF_ROWS : string = 'numberOfRows'
- Number of rows in the table at the last statistics update (`numrows`).
- PERCENT_TOUCHED : string = 'percentTouched'
- Percentage of the table that has been touched since the last statistics update (`pcttouched`).
- RECORD_SIZE : string = 'recordSize'
- Average record size in bytes (`recsize`).
- TABLE_ATTRIBUTES : string = 'tableAttributes'
- Bitmask of table attributes (`tblattributes`).
- UPDATE_STATS : string = 'updateStats'
- Timestamp of the last automatic statistics update (`updstats`).
Constants
COLUMNS
Collection of columns owned by this table (denormalized convenience key).
public
string
COLUMNS
= 'columns'
NUMBER_OF_ROWS
Number of rows in the table at the last statistics update (`numrows`).
public
string
NUMBER_OF_ROWS
= 'numberOfRows'
PERCENT_TOUCHED
Percentage of the table that has been touched since the last statistics update (`pcttouched`).
public
string
PERCENT_TOUCHED
= 'percentTouched'
RECORD_SIZE
Average record size in bytes (`recsize`).
public
string
RECORD_SIZE
= 'recordSize'
TABLE_ATTRIBUTES
Bitmask of table attributes (`tblattributes`).
public
string
TABLE_ATTRIBUTES
= 'tableAttributes'
UPDATE_STATS
Timestamp of the last automatic statistics update (`updstats`).
public
string
UPDATE_STATS
= 'updateStats'