Creating column table in SAP HANA database



To create a Column store table, you need to enter “Column” keyword in Create table command.

Create column Table Test_ColumnTB1 (
   Cust_ID INTEGER,
   Cust_NAME VARCHAR(10),
   PRIMARY KEY (Cust_ID)
);


Advertisements