Create table SQL query in SAP HANA

SAP HANASAPSAP Basis

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

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