Create table SQL query in SAP HANA

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 unique and not null.

Create Table Demo_HANA (
   ID INTEGER,
   NAME VARCHAR(10),
   PRIMARY KEY (ID)
);

John SAP

Published on 21-Feb-2018 19:10:30

• Related Questions & Answers
• Load and unload a table in SAP HANA using SQL query
• Create User SQL in SAP HANA database
• Create View SQL in SAP HANA database
• Executing a SQL query in SAP HANA Studio
• SQL query to check SAP HANA system version
• SQL statement to create a Restricted user in SAP HANA
• Difference between Open SQL, Native SQL in SAP HANA
• Sort data in SQL using Dynamic SQL in SAP HANA
• SQL statement to add a table as Virtual table in SAP HANA Smart Data Access
• Opening SQL editor using SAP HANA Studio
• SQL Operation supported in SAP HANA SPS06 SDA
• SQL Operation supported in SAP HANA SPS07 SDA
• Viewing table definition in SAP HANA
• Changing default schema in SQL console in SAP HANA
• Converting BLOB to Char in SAP HANA using SQL