Adding new columns into existing HANA table

[former_member225922]

Hi,

     I need to add new column into an existing table in hana system. I  used normal SQL alter command for altering new column but it's not working.

ALTER TABLE table_name

ALTER COLUMN column_name datatype;

Can anyone please suggest correct syntax for this.

[Former Member · Accepted solution]

CREATE COLUMN TABLE MYTAB (SOME_FIELD INTEGER);

ALTER TABLE MYTAB ADD (ANOTHER_FIELD CHAR(1));

[former_member225922 · Accepted solution]

This message was moderated.

[Former Member]

ALTER TABLE <tablename> ADD (<columnname> <datatype>);

Example:

ALTER TABLE "PROCUREMENT"."TEST_DATA" ADD (STATE VARCHAR(10));

[former_member225922]

Hi Abhishek,

I tried with your syntax its working fine.

Thank you.