Skip to Content
avatar image
Former Member

Converting a hdbtable

Hi,

I have created a hdb table of row type and could any one let me know how it can be converted to a column table.

Thanks in advance.

Regards,

Jyothirmayi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    May 25, 2016 at 09:37 AM

    Hi,

    you can convert ROW to COLUMN using the below SQL

    alter table <schema name>.<table name> column

    Thank you

    Regards

    priyanka

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      You can use SE11--> table name --> Technical settings --> DB specific properties tab and choose Column store radio button.

      Regards

      Prithviraj

  • avatar image
    Former Member
    May 30, 2016 at 10:29 AM

    Hi Priyanka and Pruthviraj,

    Thank you for your reply. The .hdb table has been created in Hana Development Perspective(Hana Studio).

    Hence the code "alter table <schema name>.<table name> column" doesn't work and also SE11.

    I have deleted the Row table and created a column table once again. I think this is the only solution as of now.

    Add comment
    10|10000 characters needed characters exceeded