Drop partition if exists in HANA

Question

I would like to know if there is a way to DROP a partition IF EXISTS in HANA.

I have tried like below

ALTER TABLE TBL_NAME DROP IF EXISTS PARTITION VALUE = '1234'

I am getting incorrect syntax error near IF

What is the best available solution?

Answer

HANA does not support the IF EXISTS clause.

You may want to work around this limitation by implementing your own “IF EXISTS”, similar to what I presented here: If EXISTS would exist

Accepted Answer

HANA does not support the IF EXISTS clause.You may want to work around this limitation by implementing your own &#8220;IF EXISTS&#8221;, similar to what I presented here:If EXISTS would exist

Advertisement

Answer