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);