How to Create Table in SAP HANA – Part 1

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

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