HANA SQL笔记

一、HANA表

修改表的主键：先删除主键，再添加主键:

alter table "SCHEMANAME"."DIM_CUSTOMER" drop primary key ;alter table "SCHEMANAME"."DIM_CUSTOMER" add primary key ("ID")；

修改表的存储分区:ALTER TABLE "SCHEMANAME"."DIM_CUSTOMER" WITH PARAMETERS ('PARTITION_SPEC' = 'HASH 12 IDENT,ID');

   /*新增字段: */ ALTER TABLE "SCHEMANAME"."DIM_CUSTOMER" ADD ("COLUMNNAME" NVARCHAR(30));     

 /* 修改表的字段（类型或长度）: */ ALTER TABLE "SCHEMANAME"."DIM_CUSTOMER" ALTER("COLUMNNAME" newDataType(newLengthValue));

 /* 删除字段: */ ALTER TABLE "SCHEMANAME"."DIM_CUSTOMER" DROP ("COLUMNNAME");