Different table symbol in SAP HANA database



In SAP HANA Studio, you can check the table type from table symbol under Schema. In below snapshot you can see the different symbol for row table and a column table.

TEST_Row − Row store table.

SHOPFACT − Column store table

To change the table type, you can use alter table command.

Alter table column table_name;


Advertisements