Clickhouse DDL&DML

(1)添加列:

alter table [db.]table_name add column column_name [type] [default_expr] [after name_after]

type:类型

default_expr:默认值

after name_agter:把新列添加在指定列后面

(2)删除列:

alter table [db.]table_name drop column column_name

(3)修改列

alter table [db.]table_name modify column column_name [type] [default_expr]

 (4)删除分区

alter table [db.]table drop partition 'partition_name'

  

原文地址:https://www.cnblogs.com/vdvvdd/p/9848381.html