Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

want to add column in HANA Tables

Hi ,

I have created a table with few columns and loaded the data.Now I would like to add a new column and load the data to it .Could you please let me know how to do it.

Tags:
Former Member
Former Member replied

Hi Sreelatha-

There are some posts already related to adding/removing a column . Please check before posting a new thread.

Adding a new column:

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

Example:


ALTER TABLE emp_t ADD(emp_id nvarchar(10));


Removing an existing column:

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

Example:


ALTER TABLE emp_t DROP(emp_id nvarchar(10));

Thanks

Happy learning

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question