Database Property System Procedures and Functions

These are the system procedures and functions for working with your database properties:

Procedure / Function Name Description
SYSCS_UTIL.SYSCS_GET_ALL_PROPERTIES Displays all of the Splice Machine Derby properties.
SYSCS_UTIL.SYSCS_GET_GLOBAL_DATABASE_PROPERTY function Fetches the value of the specified property of the database.
SYSCS_UTIL.SYSCS_GET_SCHEMA_INFO Displays table information for all user schemas, including the HBase regions occupied and their store file size.
SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE function

Allows users to observe the instantaneous current value of a sequence generator without having to query the SYSSEQUENCES system table.

SYSCS_UTIL.SYSCS_SET_GLOBALDATABASE_PROPERTY Sets or deletes the value of a property of the database.