Skip to Content
Author's profile photo Priyanka Joshi

How to Create Table in SAP HANA – Part 1

In my earlier blog I’ve explained how to create SAP HANA database connection ––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


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


  • 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.


  • 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.


  • 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.


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


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


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


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.