SAP HANA SQL
-- Alter Table: --------------- CREATE COLUMN TABLE "QBEXSQL"."EMPtab4ALTER" ( "EMPID" INT , "EMPNAME" VARCHAR(20), "DEPTNO" VARCHAR(5) ); -- Add New Column: ------------------ ALTER TABLE "QBEXSQL"."EMPtab4ALTER" ADD ("DEPTNAME" VARCHAR(20)); -- Drop Column --------------- ALTER TABLE "QBEXSQL"."EMPtab4ALTER" DROP ( "DEPTNAME" ); -- Alter Column Definition -------------------------- ALTER TABLE "QBEXSQL"."EMPtab4ALTER" ALTER ( "DEPTNO" VARCHAR(10)); ALTER TABLE "QBEXSQL"."EMPtab4ALTER" ALTER ( "EMPID" BIGINT); -- Add Constraint ----------------- ALTER TABLE "QBEXSQL"."EMPtab4ALTER" ADD CONSTRAINT PK PRIMARY KEY ("EMPID"); -- Drop Primary key -------------------- ALTER TABLE "QBEXSQL"."EMPtab4ALTER" DROP PRIMARY KEY; -- Preload Clause ----------------- ALTER ...