数智融合计算服务 DATAARTSFABRIC-ALTER TABLE:语法格式

时间：2025-06-17 08:50:21

数智融合计算服务 DATAARTSFABRIC DDL语法

语法格式

  
       ALTER TABLE table_name DROP PARTITIONS ( col_name = col_value [, ... ] ) [, ... ];
ALTER TABLE table_name ADD COLUMNS ( col_name col_type [ COMMENT col_comment ] [, ... ] );
ALTER TABLE table_name DROP COLUMNS ( col_name [, ... ] );
ALTER TABLE table_name COLUMN col_name RENAME TO col_name_new;
ALTER TABLE table_name ALTER COLUMN col_name col_name_new col_type [ COMMENT col_comment ];
ALTER TABLE table_name RENAME TO table_name_new;
ALTER TABLE table_name SET TABLEPROPERTIES ( option_key = option_value [, ... ] );
ALTER TABLE table_name UNSET TABLEPROPERTIES ( option_key [, ... ] );
ALTER TABLE table_name UPDATE COLUMNS;