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: