Skip to Content
avatar image
Former Member

How do I rename column names in HANA tables in bulk

Hi,

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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?

    Regards,

    Florian

    Add comment
    10|10000 characters needed characters exceeded