Administrative Procedures and Functions

These system procedures and functions for administering your database apply to both our on-premise and database-as-service products:

Procedure / Function Name Description
SYSCS_UTIL.CHECK_TABLE Reports on inconsistencies between a table and its indexes.
SYSCS_UTIL.SYSCS_CREATE_USER Adds a new user account to a database.
SYSCS_UTIL.SYSCS_DROP_USER Removes a user account from a database.
SYSCS_UTIL.INVALIDATE_DICTIONARY_CACHE Invalidates the dictionary cache on the connection's region server.
SYSCS_UTIL.INVALIDATE_GLOBAL_DICTIONARY_CACHE Invalidates the dictionary cache on all region servers.
SYSCS_UTIL.KILL_OPERATION Terminates a Splice Machine operation running on the server to which you are connected.
SYSCS_UTIL.SYSCS_MODIFY_PASSWORD Called by a user to change that user's own password.
SYSCS_UTIL.SYSCS_PERFORM_MAJOR_COMPACTION_ON_SCHEMA Performs a major compaction on a schema
SYSCS_UTIL.SYSCS_PERFORM_MAJOR_COMPACTION_ON_TABLE Performs a major compaction on a table.
SYSCS_UTIL.SYSCS_REFRESH_EXTERNAL_TABLE Refreshes the schema of an external table in Splice Machine; use this when the schema of the table's source file has been modified outside of Splice Machine.
SYSCS_UTIL.SYSCS_RESET_PASSWORD Resets a password that has expired or has been forgotten.
SYSCS_UTIL.SYSCS_UPDATE_SCHEMA_OWNER Changes the owner of a schema.
SYSCS_UTIL.VACUUM Performs clean-up operations on the system.

These system procedures and functions for administering your database only apply to our on-premise product:

Procedure / Function Name Description

Backs up the database to a specified backup directory.


Cancels a backup.


Delete a specific backup.


Deletes all backups that were created more than a certain number of days ago.


Restores a database from a previous backup.