---
metadata:
  - name: generator
    content: Diplodoc Platform v5.50.6
alternate:
  - https://ydb.tech/docs/en/yql/reference/syntax/alter_database/settings.md?version=main
  - https://ydb.tech/docs/ru/yql/reference/syntax/alter_database/settings.md?version=main
sourcePath: en/core/yql/reference/syntax/alter_database/settings.md
---
> **Documentation Index:** Fetch the complete configuration index at https://ydb.tech/docs/en/llms.txt

# Change database settings

Changes database settings. Only a database administrator can perform this operation.

## Syntax

```yql
ALTER DATABASE path SET (key = value, ...)
```

### Parameters

* `path` — path to the database.
* `key` — name of the setting to change:
  * `MAX_PATHS` — [maximum number of paths](https://ydb.tech/docs/en/concepts/limits-ydb.md?version=main#schema-object) (schema objects) in the database.
  * `MAX_SHARDS` — [maximum number of tablets](https://ydb.tech/docs/en/concepts/limits-ydb.md?version=main#schema-object) in the database.
  * `MAX_CHILDREN_IN_DIR` — [maximum number of objects in a directory](https://ydb.tech/docs/en/concepts/limits-ydb.md?version=main#schema-object).
  * `MAX_SHARDS_IN_PATH` — [maximum number of tablets associated with a single schema object](https://ydb.tech/docs/en/concepts/limits-ydb.md?version=main#schema-object). For example, the maximum number of partitions of one table.
* `value` — new value for the setting.

## Examples

Change the limit on the maximum number of paths (schema objects) for database `/Root/test`:

```yql
ALTER DATABASE `/Root/test` SET (MAX_PATHS = 20000);
```