System Information Tables

This section contains the reference documentation for the Splice Machine SQL System Tables containing system information.

Since the system tables belong to the SYS schema, you must preface any inquiries involving these tables with the SYS. prefix.

The System Information Tables are:

System Table Description
SYSCONGLOMERATES Describes the conglomerates within the current database. A conglomerate is a unit of storage and is either a table or an index.
SYSFILES Describes jar files stored in the database.
SYSSTATEMENTS Describes the prepared statements in the database.
SYSUSERS Stores user credentials when NATIVE authentication is enabled.