---
metadata:
  - name: generator
    content: Diplodoc Platform v5.52.0
alternate:
  - https://ydb.tech/docs/en/yql/reference/syntax/alter_table/set.md?version=v25.3
  - https://ydb.tech/docs/ru/yql/reference/syntax/alter_table/set.md?version=v25.3
  - href: en/yql/reference/syntax/alter_table/set.md
    type: text/markdown
    title: Markdown version
  - href: ../../../../llms.txt
    type: text/markdown
    title: llms.txt
sourcePath: en/core/yql/reference/syntax/alter_table/set.md
---
> **Documentation Index:** Fetch the complete configuration index at https://ydb.tech/docs/en/llms.txt

# Modifying additional table parameters

Most parameters of row and column tables in YDB, listed on the [table description](https://ydb.tech/docs/en/concepts/datamodel/table.md?version=v25.3) page, can be modified using the `ALTER` command.

Generally, the command to modify any table parameter looks as follows:

```sql
ALTER TABLE table_name SET (key = value);
```

`key` — the name of the parameter, `value` — its new value.

Example of modifying the `TTL` parameter, which controls the time-to-live of records in a table:

```sql
ALTER TABLE series SET (TTL = Interval("PT0S") ON expire_at);
```

## Resetting Additional Table Parameters {#additional-reset}

Some table parameters in YDB, listed on the [table description](https://ydb.tech/docs/en/concepts/datamodel/table.md?version=v25.3) page, can be reset using the `ALTER` command. The command to reset a table parameter looks as follows:

```sql
ALTER TABLE table_name RESET (key);
```

`key` — the name of the parameter.

For example, such a command will reset (remove) the `TTL` settings for row or column tables:

```sql
ALTER TABLE series RESET (TTL);
```