SAP Basis Articles - Page 16 of 60

You can also create a table in the HANA database using GUI option in the HANA studio. To create a new table, you need to select Schema right-click → New Table and in the right pane, you can define the table.In table creation wizard, you need to enter TABLE NAME and Scheme in which you want to create this table and Table Type- Row or Column Store or Table Type.To add columns to the table, you need to click on “+” sign and a new column is added. You have to define an SQL data type, dimension and Key in ... Read More

To convert a Column store table to row store, you can use the following SQL statement −Alter table Table_Name row;

You can also convert a Column store table to a Row store table or a Row store table to Column store table using ALTER table command.Alter table "AA_HANA11"."DEMO_HANA" column;

Yes, it is possible to differentiate between both the table types.  When you go to schema and view the newly created table, you can see vertical lines in front of table name and it confirms that this is column store table.In below pic, you can see the difference between a Row store table and Column store table.

To create a Column store table, you need to enter “Column” keyword in Create table command.Create column Table Test_ColumnTB1 (    Cust_ID INTEGER,    Cust_NAME VARCHAR(10),    PRIMARY KEY (Cust_ID) );

To check table definition, you need to right click on table name → Open Definition and this will open table structure under HANA database.

When the data is entered, you can see the data in this row-based table by going to the Data Preview option. To see the data, right-click on table name → Open Data PreviewWhen you run Data Preview of a table, you can see full data under the Raw Data tab. You can also view distinct values and perform some analysis.

To insert the data, you need to run the Insert statement in SQL editor. “Demo_HANA” is table name.Insert into Demo_HANA Values (1,'John'); Insert into Demo_HANA Values (2,'Anna'); Insert into Demo_HANA Values (3,'Jason'); Insert into Demo_HANA Values (4,'Nick');In SQL editor, add INSERT statements and execute (F8) as below −

By default it creates a Row store table. The horizontal lines in front of table name represents row based storage table in database. HANA database also supports column store tables but you need to add a keyword “Column” in create table query.Below snapshot confirms that by default a row based table is created.

Let us say you have executed the below create table SQL statement in HANA database −Create Table Demo_HANA ( ID INTEGER, NAME VARCHAR(10), PRIMARY KEY (ID) );To check the table in HANA database, navigate to AA_HANA11 schema and right click and refresh (F5). Navigate to “Table” folder and you can see new table with name Demo_HANA is created.