When you use the Auto documentation feature in SAP HANA, you can navigate to job log → Current tab and select Job-type Auto Documentation and double click.You can see details of Auto Documentation job details and Status- shows a green tick mark as successful. 

When a SQL query is executed, you can see the confirmation that the query is executed in time duration and also with server processing time. In this scenario, you can see the time taken by SAP HANA processor to create a new table in the HANA database as below −“Statement ... Read More

In below SQL query, you can see a create table command in SQL editor to create a new table with name-“Demo_HANA” in schema name AA_HANA11 with column names- ID and NAME and corresponding data types. In the below example, we have defined ID as “Primary Key” which means it is ... Read More

If you open SAP HANA cockpit, you can see different database functions in the HANA system − https://best:4303/sap/hana/admin/cockpit

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. ... Read More

In below SQL statement you have to define orcl_DSN_Name −CREATE REMOTE SOURCE Source_Name ADAPTER “odbc” CONFIGURATION FILE ‘property_orcl.ini’ CONFIGURATION ‘DSN=oral_DSN_Name’ WITH CREDENTIAL TYPE ‘PASSWORD’ USING ‘user=username;password=password′;In this SQL statement- can be as per remote data source and take these values- TDODBC, HIVEODBC, ASEODBC, IQODBC and ODBC.In above statement, ... Read More

To execute the table creation, click on the green arrow mark on the top right corner. You will get a confirmation as below that a column table has been created in Schema AA_HANA11 with name DEMO_TABLE −Statement 'create column table "AA_HANA11"."DEMO_TABLE"( "CUST ID" INTEGER null, "CUST NAME" VARCHAR (10) null)' ... Read More

Following table type available in SAP HANA Studio −RowColumnTable Type − this can be changed later as per requirement

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 ... Read More

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) );