# 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.

If the value that was set for the property is invalid, the `SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY` function returns the invalid value, but Derby uses the default value.

## Syntax

    VARCHAR(32672) SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY(IN KEY VARCHAR(128))

An error will be returned if KEY is null.

## Execute privileges

If authentication and SQL authorization are both enabled, only the database owner has execute privileges on this function by default. See "Configuring user authentication" and "Configuring user authorization" in the Derby Security Guide for more information. The database owner can grant access to other users.

## SQL example

Retrieve the value of the `derby.locks.deadlockTimeout` property:

    VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.locks.deadlockTimeout');

Parent topic: Built-in system functions
Related reference
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY system procedure