# Scope of Derby properties

A property in Derby belongs to one or more of these scopes:

- system-wide

  System-wide properties apply to an entire system, including all its databases and tables if applicable.

  - Set programmatically

    System-wide properties set programmatically have precedence over database-wide properties and system-wide properties set in the derby.properties file.

  - Set in the derby.properties file

    The derby.properties file is an optional file that can be created to set properties at the system level when the Derby driver is loaded. Derby looks for this file in the directory defined by the derby.system.home property. Any property except derby.system.home can be set by including it in the derby.properties file.

- database-wide

  A database-wide property is stored in a database and is valid for that specific database only.

  Note: Database-wide properties are stored in the database and are simpler for deployment. System-wide parameters are probably easier for development.

For more information about scopes, precedence, and persistence, see Properties overview

Parent topic: Derby properties
Related concepts
Derby properties