hana数据库-修改表名
CREATE TABLE mySchema.A (A INTPRIMARYKEY, B INT);SELECT TABLE_NAME FROM TABLES WHERE SCHEMA_NAME = 'MYSCHEMA';RENAME TABLE mySchema.A TO B;
hana数据库-修改表类型
ALTER TABLE accounts COLUMN THREADS 10 BATCH 10000;ALTER TABLE accountsROW THREADS 10;
hana数据库-修改表约束
ALTER TABLE "SCHEMA1"."TABLE1" DROP PRIMARY KEY;ALTER TABLE "SCHEMA1"."TABLE1" ADD PRIMARY KEY(TID, TNAME);
hana数据库-增加字段
ALTER TABLE "SCHEMA1"."TABLE1" ADD("CREATETIME" DATE NULL) ;ALTER TABLE "SCHEMA1"."TABLE1" DROP (COL1);
hana数据库-修改字段(名称、类型)
RENAME COLUMN <table_name>.<old_column_name> TO <new_column_name>;ALTER TABLE "SCHEMA1"."TABLE1" ALTER ("TYPE" NVARCHAR (10) NULL);