Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Find a specific Temporary Table in Hana

Hi Experts, I'm trying to validate if an specific temporary table is already created to avoid duplicates. How can I do that?

Could be something like

IF temp_table exists

     truncate or drop table

     create table again

else

//some code

Thanks in advance!

Message was edited by: Tom Flanagan

Tags:
Former Member
replied

Just drop the table and catch the exception. If you're going to drop it anyhow, just put a drop and create in place. Then if it doesn't exist it creates an exception, which you can catch and ignore.

Exception Handling of SAP HANA SQLScript Procedure

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question