Convert Row Store to Column Store Table

we are going discuss , about row store to column store conversion and column store to row store conversion in HANA database at table Level.

Row Store to Column Store Conversion :

Its possible with below SQL command to convert row table to column table.

ALTER TABLE {Schema_Name}.{Table_Name} COLUMN

Column Store to Row Store Conversion :

Replace COLUMN with ROW to convert from column to row table .

ALTER TABLE {Schema_Name}.{Table_Name} ROW

Example:

Alter table "HANADBXY"."LOCK_ABC_LOCK" row 

Topic on - Row Store Table in SAP HANA
Topic on - Column Store Table in SAP HANA