|
System table
|
Summary description
|
|
SYSTABLES
|
Core system table; one row for each TABLE in the database
|
|
SYSCOLUMNS
|
Core system table; one row for each COLUMN of each table in the database
|
|
SYSINDEXES
|
Core system table. One row for each component of each INDEX in the database
|
|
SYSCALCTABLE
|
A single row with a single column set to the value 100
|
|
SYSNCHARSTAT
|
One row for each CHARACTER column in the database
|
|
SYSCOLAUTH
|
One row for each column for each user holding privileges on the column
|
|
SYSCOLSTAT
|
Provides statistical information on data distribution
|
|
SYSCOLUMNS_FULL
|
Superset of information in core system table SYSCOLUMNS
|
|
SYSDATATYPES
|
Information on supported data types
|
|
SYSDATESTAT
|
One set of rows for each DATE column in the database
|
|
SYSDBAUTH
|
One row for each user with database-wide privileges
|
|
SYSFLOATSTAT
|
One set of rows for each FLOAT column in the database
|
|
SYSIDXSTAT
|
Information on indexes in the database
|
|
SYSINTSTAT
|
One set of rows for each INTEGER column in the database
|
|
SYSNUMSTAT
|
One set of rows for each NUMERIC column in the database
|
|
SYSPROCBIN
|
One row for each compiled Java stored procedure or trigger in the database
|
|
SYSPROCCOLUMNS
|
One row for each column in the result set of a stored procedure
|
|
SYSPROCEDURES
|
One row for each stored procedure in the database
|
|
SYSPROCTEXT
|
One row for each Java source code for a stored procedure or trigger in the database
|
|
SYSREALSTAT
|
One set of rows for each REAL column in the database
|
|
SYSSEQAUTH
|
One row for each unique user/sequence combination, holding sequence privileges on a sequence of the database
|
|
SYSSEQUENCES
|
View of OpenEdge schema table_sequence
|
|
SYSSMINTSTAT
|
One set of rows for each SMALLINT column in the database
|
|
SYSSYNONYMS
|
One row for each SYNONYM in the database
|
|
SYSTABAUTH
|
One row for each unique user/table combination holding table privileges on a table in the database
|
|
SYSTABLES_FULL
|
Superset of information in core system table SYSTABLES
|
|
SYSTBLSTAT
|
Contains statistics for user tables in the database
|
|
SYSTIMESTAT
|
One set of rows for each TIME column in the database
|
|
SYSTINYINTSTAT
|
One set of rows for each TINYINT column in the database
|
|
SYSTRIGCOLS
|
One row for each column specified in each trigger in the database
|
|
SYSTRIGGER
|
One row for each trigger in the database
|
|
SYSTSSTAT
|
One set of rows for each TIMESTAMP column in the database
|
|
SYSTSTZSTAT
|
One set of rows for each TIMESTAMP WITH TIME ZONE column in the database
|
|
SYSNVARCHARSTAT
|
One set of rows for each VARCHAR column in the database
|
|
SYSVIEWS
|
One row for each VIEW in the database
|
|
SYS_CHKCOL_USAGE
|
One row for each CHECK CONSTRAINT defined on a column in the database
|
|
SYS_CHK_CONSTRS
|
One row for each CHECK CONSTRAINT defined on a user table in the database
|
|
SYS_KEYCOL_USAGE
|
One row for each column in the database defined with a PRIMARY KEY or FOREIGN KEY
|
|
SYS_REF_CONSTRS
|
One row for each table in the database defined with a REFERENTIAL INTEGRITY CONSTRAINT
|
|
SYS_TBL_CONSTRS
|
One row for each CONSTRAINT defined on a table in the database
|