Table Types in Hana

Here , we are going to discuss about table types in SAP HANA database and how to create table by using SQL Command and HANA Studio.

SAP HANA supports two types tables.

1 - Row Store table
2 - Column Store table

In this session, we will learn :

-    How to create, update and delete tables in SAP HANA.
-    How to see definition and data preview of tables.
-    How to change column type of a table.

Create a Table Using Standard SQL:

1.    Select your Schema. Right click and select "SQL Console". Otherwise you can also click on "SQL" button on top panel as shown in below figure.

2.    Copy the SQL statement below in SQL editor.

            CREATE COLUMN TABLE TEST_TABLE1 (
            ID INTEGER,
            NAME VARCHAR(10),
            DESCRIPTION VARCHAR(100),
            PRIMARY KEY (ID)
             );

   3.    Click on Execute.

  4.    Right-click on Tables under the Navigator Tab and click on Refresh to display the name of the            newly created table.

 5.    Right click on the table and click on "Open Definition" to see the table details.

Create a Table with The SAP HANA Studio Tools:

1.    Select your Schema. Right click and select "New Table"

2.    Enter the Table Name

3.    Choose the Table Type, e.g. "Column Store"

4.    Enter the required table fields, data types, Key characteristics, etc. by clicking on the "+" sign              below, and click on the Create table icon (or F8) when ready.

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