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

OpenEdge SQL System Catalog Tables

OpenEdge® SQL maintains a set of system tables for storing information about tables, columns, indexes, constraints, and privileges. This section describes those system catalog tables.
* Overview of system catalog tables
* SYSTABLES
* SYSCOLUMNS
* SYSINDEXES
* SYSCALCTABLE
* SYSNCHARSTAT
* SYSCOLAUTH
* SYSCOLSTAT
* SYSCOLUMNS_FULL
* SYSDATATYPES
* SYSDATESTAT
* SYSDBAUTH
* SYSFLOATSTAT
* SYSIDXSTAT
* SYSINTSTAT
* SYSNUMSTAT
* SYSPROCBIN
* SYSPROCCOLUMNS
* SYSPROCEDURES
* SYSPROCTEXT
* SYSREALSTAT
* SYSSEQAUTH
* SYSSEQUENCES
* SYSSYNONYMS
* SYSTABAUTH
* SYSTABLES_FULL
* SYSTBLSTAT
* SYSTIMESTAT
* SYSTINYINTSTAT
* SYSTRIGCOLS
* SYSTRIGGER
* SYSTSSTAT
* SYSTSTZSTAT
* SYSNVARCHARSTAT
* SYSVIEWS
* SYS_CHKCOL_USAGE
* SYS_CHK_CONSTRS
* SYS_KEYCOL_USAGE
* SYS_REF_CONSTRS
* SYS_TBL_CONSTRS