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

Updated on: 22-Jun-2020

5K+ Views

Kickstart Your Career

Get certified by completing the course

Get Started
Advertisements