ttl.md 661 字节
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12
---
toc_priority: 44
toc_title: TTL
---

### Manipulations with Table TTL {#manipulations-with-table-ttl}

You can change [table TTL](../../../engines/table-engines/mergetree-family/mergetree.md#mergetree-table-ttl) with a request of the following form:

``` sql
ALTER TABLE table-name MODIFY TTL ttl-expression
```
A
Draft.  
ana-uvarova 已提交
13 14 15

# ALTER TABLE REMOVE TTL

A
++  
ana-uvarova 已提交
16
Removes ttl-property from the column.
A
ana-uvarova 已提交
17

A
Draft.  
ana-uvarova 已提交
18 19 20
Syntax:

```sql
A
++  
ana-uvarova 已提交
21
ALTER TABLE table_name REMOVE TTL 
A
Draft.  
ana-uvarova 已提交
22 23 24
Syntax of the statement.
```

A
++  
ana-uvarova 已提交
25
ALTER TABLE r_no_prop_table MODIFY COLUMN some_column REMOVE TTL;
A
Draft.  
ana-uvarova 已提交
26

A
++  
ana-uvarova 已提交
27
**Example**
A
Draft.  
ana-uvarova 已提交
28

A
++  
ana-uvarova 已提交
29
Request
A
Draft.  
ana-uvarova 已提交
30

A
++  
ana-uvarova 已提交
31 32 33 34 35 36 37
```sql

```

Result

```text
A
++  
ana-uvarova 已提交
38

A
++  
ana-uvarova 已提交
39
```
A
Draft.  
ana-uvarova 已提交
40 41 42 43 44 45

## See Also (Optional)

Links to related topics as a list.

-   [link](#)