Converting a hdbtable

[Former Member]

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

[Former Member]

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.

[Former Member]

Hi,

you can convert ROW to COLUMN using the below SQL

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

Thank you

Regards

priyanka

[Former Member]

Hi,

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

Regards

Prithviraj