System Tables

This section contains the reference documentation for the Splice Machine SQL Statements, in the following subsections:

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

You can use the Java java.sql.DatabaseMetaData class to learn more about these tables.

Database Backups Tables

The following table lists the System Tables with backups information:

The tables listed in this section apply only to our on-premise database product.

System Table Description
SYSBACKUP Information about each run of a backup job that has been run for the database. You can query this table to determine status information about a specific backup job.
SYSBACKUPITEMS Information about the items backed up for each backup job.
SYSBACKUPJOBS Information about all backup jobs that have been created for the database.

Database Objects Tables

These are the System Tables with information about database objects:

System Table Description
SYSALIASES Describes the procedures, functions, and user-defined types in the database.
SYSCHECKS Describes the check constraints within the current database.
SYSCOLUMNS Describes the columns within all tables in the current database.
SYSCONSTRAINTS Describes the information common to all types of constraints within the current database.
SYSDEPENDS Stores the dependency relationships between persistent objects in the database.
SYSFOREIGNKEYS Describes the information specific to foreign key constraints in the current database.
SYSKEYS Describes the specific information for primary key and unique constraints within the current database.
SYSROLES Stores the roles in the database.
SYSSCHEMAS Describes the schemas within the current database.
SYSSEQUENCES Describes the sequence generators in the database.
SYSSNAPSHOTS Stores metadata for a Splice Machine snapshot.
SYSTABLES Describes the tables and views within the current database.
SYSTRIGGERS Describes the triggers defined for the database.
SYSVIEWS Describes the view definitions within the current database.

Database Permissions Tables

These are the System Tables with database permissions information:

System Table Description
SYSCOLPERMS Stores the column permissions that have been granted but not revoked.
SYSPERMS Describes the usage permissions for sequence generators and user-defined types.
SYSROUTINEPERMS Stores the permissions that have been granted to routines.
SYSTABLEPERMS Stores the table permissions that have been granted but not revoked.

Database Statistics Tables

These are the System Tables and Views with database statistics information:

System Table/View Description
SYSCOLUMNSTATISTICS Statistics gathered for each column in each table.
SYSTABLESTATISTICS Describes the statistics for each table within the current database.

System Information Tables

These are the System Tables with system information:

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.