alter-table.md 755 B
title: "ALTER TABLE"
description: "ALTER TABLE changes the parameters of a table."
menu:
main:
parent: 'commands'
ALTER TABLE changes the parameters of a table.
Syntax
{{< diagram "alter-table-set.svg" >}} {{< diagram "alter-table-reset.svg" >}}
| Field | Use |
|---|---|
| name | The identifier of the table you want to alter. |
| _retentionperiod | *Private preview. This option has known performance or stability issues and is under active development.* Duration for which Materialize retains historical data, which is useful to implement durable subscriptions. Accepts positive interval values (e.g. '1hr'). Default: 1s. |