Change column name in a table in clickhouse

Change the name of one column:
ALTER TABLE tablename RENAME COLUMN old_name TO new_name

Change the names of multiple columns:
ALTER TABLE tablename
    RENAME COLUMN old_name1 TO new_name1,
    RENAME COLUMN old_name2 TO new_name2

Comments

Popular posts from this blog

BdsDex: failed to load Boot0001 "UEFI BHYVE SATA DISK BHYVE-OABE-20A5-E582" from PciRoot(0x0)/Pci (0x2, 0x0)/Stat(0x0,0xFFFF,0x0) : Not Found

Install Shadowsocks-libev as Client on Debian Linux

FreeBSD安装SCIM中文输入法(csh/tcsh)