Deleting from temporary table in SAP HANA

The temporary tables are session specific. So you would require to use truncate instead of delete as follows

truncate table #temptable;

Also, could you please check your release? In the recent releases, delete also works fine. Here is an example:

Drop table #temptable;
Create local temporary table #temptable(id integer, str nvarchar(30));
Insert into #temptable values (1,'abc');
Insert into #temptable values (2,'xyz');
Select * from #temptable;  --> returns 3 rows
Delete from #temptable;
Select * from #temptable;--> returns 0 rows

Vikyath Ram

Published on 14-Dec-2017 05:39:01

• Related Questions & Answers
• Using temporary license in SAP HANA
• Deleting inactive objects in SAP HANA
• Deleting all license key in SAP HANA
• Viewing table definition in SAP HANA
• Inserting data in table in SAP HANA
• Deleting subsequent heading from report in SAP system
• Table type while importing data from flat file in SAP HANA
• Maximum Table name length in SAP HANA
• Creating a new table in SAP HANA
• Different table symbol in SAP HANA database
• Create table SQL query in SAP HANA
• Default table type in SAP HANA database
• Creating column table in SAP HANA database
• Password blacklist table in SAP HANA database
• Opening SAP HANA Cockpit from HANA Studio