# Built-in system functions

This section describes the different built-in system functions available with Derby.

- SYSCS_UTIL.SYSCS_CHECK_TABLE system function
  The SYSCS_UTIL.SYSCS_CHECK_TABLE function checks the specified table, ensuring that all of its indexes are consistent with the base table.
- SYSCS_UTIL.SYSCS_GET_DATABASE_NAME system function
  The SYSCS_UTIL.SYSCS_GET_DATABASE_NAME function returns the name of the database of the current connection.
- SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY system function
  The SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY function fetches the value of the specified property of the database on the current connection.
- SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS system function
  The SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS function returns a VARCHAR(32672) value representing the query execution plan and runtime statistics for a java.sql.ResultSet.
- SYSCS_UTIL.SYSCS_GET_USER_ACCESS system function
  The SYSCS_UTIL.SYSCS_GET_USER_ACCESS function returns the current connection access permission for the user specified.
- SYSCS_UTIL.SYSCS_GET_XPLAIN_MODE system function
  The SYSCS_UTIL.SYSCS_GET_XPLAIN_MODE function returns the current XPLAIN mode.
- SYSCS_UTIL.SYSCS_GET_XPLAIN_SCHEMA system function
  The SYSCS_UTIL.SYSCS_GET_XPLAIN_SCHEMA function returns the XPLAIN schema for the connection.
- SYSCS_UTIL.SYSCS_PEEK_AT_IDENTITY system function
  The SYSCS_UTIL.SYSCS_PEEK_AT_IDENTITY function allows users to observe the next value which will be issued for an identity column.
- SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE system function
  The 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.

Parent topic: SQL language reference
Related concepts
SQL identifiers
Statements
Built-in system procedures
Data types
Related reference
Capitalization and special characters
SQL clauses
SQL expressions
JOIN operations
SQL queries
Built-in functions
SYSCS_DIAG diagnostic tables and functions