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
Thanks in advance!
Message was edited by: Tom Flanagan
John Appleby 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.