列存表修改表结构和行存表语法一致，使用ALTER TABLE 语句对指定表进行操作

ALTER TABLE table_name ;

其中， 操作包括：增加字段，删除字段，修改字段名，修改表名等。

增加字段

列存表修改表名和行存表语法一致，使用ADD COLUMN 语句增加字段。

teledb=# alter table t1 add column c1 int;
ALTER TABLE
teledb=# \d+ t1
                                     Table "public.t1"
 Column |  Type   | Collation | Nullable | Default | Storage  | Stats target | Description 
--------+---------+-----------+----------+---------+----------+--------------+-------------
 a      | integer |           |          |         | plain    |              | 
 b      | integer |           |          |         | plain    |              | 
 c      | text    |           |          |         | extended |              | 
 c1     | integer |           |          |         | plain    |              | 
Distribute By: HASH(a)
Location Nodes: ALL DATANODES

删除字段

列存表修改表名和行存表语法一致，使用DROP COLUMN 语句删除字段。

teledb=# alter table t1 drop column c1;
ALTER TABLE
teledb=# \d+ t1
                                     Table "public.t1"
 Column |  Type   | Collation | Nullable | Default | Storage  | Stats target | Description 
--------+---------+-----------+----------+---------+----------+--------------+-------------
 a      | integer |           |          |         | plain    |              | 
 b      | integer |           |          |         | plain    |              | 
 c      | text    |           |          |         | extended |              | 
Distribute By: HASH(a)
Location Nodes: ALL DATANODES

修改字段名

列存表修改表名和行存表语法一致，使用RENAME COLUMN TO 语句增加字段。

teledb=# alter table t1 rename column c1 to c2;
ALTER TABLE
teledb=# \d+ t1
                                     Table "public.t1"
 Column |  Type   | Collation | Nullable | Default | Storage  | Stats target | Description 
--------+---------+-----------+----------+---------+----------+--------------+-------------
 a      | integer |           |          |         | plain    |              | 
 b      | integer |           |          |         | plain    |              | 
 c      | text    |           |          |         | extended |              | 
 c2     | integer |           |          |         | plain    |              | 
Distribute By: HASH(a)
Location Nodes: ALL DATANODES

修改列存储表名

列存表修改表名和行存表语法一致，使用RENAME TO 语句增加字段。

teledb=# alter table t1 rename to t1_new;
ALTER TABLE
teledb=# \d+ t1
Did not find any relation named "t1".
teledb=# \d+ t1_new
                                   Table "public.t1_new"
 Column |  Type   | Collation | Nullable | Default | Storage  | Stats target | Description 
--------+---------+-----------+----------+---------+----------+--------------+-------------
 a      | integer |           |          |         | plain    |              | 
 b      | integer |           |          |         | plain    |              | 
 c      | text    |           |          |         | extended |              | 
 c2     | integer |           |          |         | plain    |              | 
Distribute By: HASH(a)
Location Nodes: ALL DATANODES