Modifying additional table parameters

Most parameters of row and column tables in YDB, listed on the table description page, can be modified using the ALTER command.

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

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:

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

Resetting Additional Table Parameters

Some table parameters in YDB, listed on the table description page, can be reset using the ALTER command. The command to reset a table parameter looks as follows:

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:

ALTER TABLE series RESET (TTL);
Previous