Creating a table using SAP HANA Studio UI option

SAP HANASAPSAP Basis

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 the table.

In below Pic, the following details are selected under table creation −

Table Name − DEMO_TABLE

SCHEMA − AA_HANA11

Type − Column Store


raja
Published on 21-Feb-2018 18:31:49
Advertisements