Skip to Content

In my earlier blog I’ve explained how to create SAP HANA database connection – http://scn.sap.com/blogs/priyankajjoshi/2013/03/21/how-to-create-table-in-sap-hana–part-1

This blog will give step by step explaination for Table creation.


  • Table can be created using two options
    • Create table using New Table option
    • Create table using Import data option.
  • Now, we will see steps to create table using New Table option
    • open Catalog folder from the connection
    • Go to the schema having your username as description
    • Go to Tables folder, which is currently empty, right click and select New Table option

TAB_P5.JPG

  • New tab will get open with empty template for Table.

TAB_P6.JPG

  • Schema name and Table type will be populated.
    • By de-fault Table type will be Column Store, which can be changed using drop-down list given.

TAB_P7.JPG

  • Enter values for
    • Table name
    • Field name – should not start with special character.
    • Select SQL Data type from the given list
    • Select whether field is Key or not, can be Null or not
  • To add new field, use ‘+’ sign given on the next row.

TAB_P8.JPG

  • List of data types is given as TAB_P9.JPG
  • For the data types NVARCHAR, VARCHAR, FLOAT, DECIMAL, BINARY, VARBINARY; size can be specified. For rest of the types size is defined by-default and fields is non-editable.
  • Once you fill all the required fields in table, click F8 or Create Table option.

TAB_P10.JPG

  • Table creation status will be shown with a background sql statement.

TAB_P11.JPG

  • Go to Tables folder in your schema, right click and select Refresh button to see the newly created table entry. 

TAB_P12.JPG  TAB_P13.JPG

  • Right click on the table to see various functions available like
    • Table definition
    • Table content
    • Delete table

TAB_P14.JPG

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply