Skip to Content

How do I rename column names in HANA tables in bulk

Oct 21, 2016 at 07:45 PM


avatar image
Former Member


I am trying to convert the columns of the tables that were created based on the virtual tables created from a 3rd party connected via SDA. In some of the instances, like data from Microsoft SQL server, the columns (name of the column) come in as smaller case. HANA assuming that everything is defined as upper case fails during the queries.

I am thinking of renaming the columns to upper case in bulk with a procedure. Is that possible? Any ideas? Thanks very much.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Florian Pfeffer
Oct 21, 2016 at 09:03 PM

What kind of queries are you doing? HANA does not assume "by default" that column names are in upper case, it assumes that only if you do not set the column names in double quotes.

For instance if you have a column MyColumn and you use it in a query w/o double quotes, a column MYCOLUMN is searched. If you set it in double quotes, "MyColumn", than the upper/lower case is considered.

So where is the issue?



10 |10000 characters needed characters left characters exceeded