You are here: Reference Information > SQL Reference Information > SQL System Tables

SQL System Tables

NuoDB system tables are tables that exist in the NuoDB SYSTEM schema. They are used internally for NuoDB operations, however in many cases they can provide useful information to the NuoDB user, such as schema metadata information.

The system tables fall into three categories:

Category Description
SYSTEM Persistent Tables Tables that are durable and stored in the NuoDB database in the SYSTEM schema. These tables may or may not have indexes defined.
Views SQL views generated from SYSTEM tables.
SYSTEM Pseudo Tables

Information that is generated dynamically by NuoDB processes and presented as a SQL table, that is, you can use pseudo tables for example, for queries and joins, but pseudo tables do not actually persist in the NuoDB database.

Caution: Client applications should never contain code that accesses SYSTEM pseudo tables as they are subject to, and furthermore likely to, change from release to release.

See the following topics:

ALLSYSTEMFIELDS System Table Description

ALLSYSTEMTABLES System Table Description

ATOMREGISTRY System Table Description

CONNECTIONS System Table Description

CONNECTIONSTATEMENTS System Table Description

DATATYPES System Table Description

DEFAULTSTORAGEGROUPS System Table Description

DEPENDENCIES System Table Description

DOMAINS System Table Description

DUAL System Table Description

FIELDS System Table Description

FOREIGNKEYS System Table Description

FORMATS System Table Description

FUNCTIONCOLUMNS System Table Description

FUNCTIONS System Table Description

GLOBALATOMS System Table Description

INDEXES System Table Description

INDEXFIELDS System Table Description

INDEXHISTOGRAMBUCKETS System Table Description

INDEXHISTOGRAMS System Table Description

INDEXPREFIXSTATISTICS System Table Description

INDEXSTATISTICS System Table Description

JAVACLASSES System Table Description

LASTSTATEMENT System Table Description

LOCALATOMS System Table Description

LOCALATOMSEQUENCES System Table Description

LOCALCONNECTIONS System Table Description

LOCALINDEXATOMS System Table Description

LOCALQUERYTIMEOUTS System Table Description

LOCALSTATEMENTS System Table Description

LOCALTABLEATOMFIELDS System Table Description

LOCALTABLEATOMS System Table Description

MEMPROPERTIES System Table Description

NODES System Table Description

NODESTORAGEGROUPS System Table Description

OPENRESULTS System Table Description

PARTITIONCRITERIA System Table Description

PARTITIONEDTABLES System Table Description

PARTITIONIDS System Table Description

PASSWORDS System Table Description

PRIVILEGES System Table Description

PRIVTYPES System Table Description

PROCEDURECOLUMNS System Table Description

PROCEDURES System Table Description

PROPERTIES System Table Description

PSEUDOTABLEFIELDS System Table Description

PSEUDOTABLES System Table Description

QUERYSTATS System Table Description

ROLES System Table Description

SCHEMAS System Table Description

SEQUENCES System Table Description

SNAPSHOTS System Table Description

STATSCACHE System Table Description

STORAGEGROUPS System Table Description

TABLECONSTRAINTS System Table Description

TABLES System Table Description

TEMPFIELDS System Table Description

TEMPINDEXES System Table Description

TEMPINDEXFIELDS System Table Description

TEMPTABLES System Table Description

TRANSACTIONS System Table Description

TRIGGERCLASSES System Table Description

TRIGGERS System Table Description

USERROLES System Table Description

USERS System Table Description

VERSIONS System Table Description

VIEW_TABLES System Table Description