try-except block for %%sql

[NimJ]

How can I handle exceptions under %%sql ?

Below statement works:

try:
    %sql DROP INDEX index_name;
    %sql CREATE INDEX index_name ON table_name(column1, column2);
except:
    %sql CREATE INDEX index_name ON table_name(column1, column2);

But, below statement fails with syntax error

try:
    %%sql
    DROP INDEX index_name;
    CREATE INDEX index_name ON table_name(column1, column2);
except:
    CREATE INDEX index_name ON table_name(column1, column2);`

Below statement fails too with error as shown below

%%sql
try:
    DROP INDEX index_name;
    CREATE INDEX index_name ON table_name(column1, column2);
except:
    CREATE INDEX index_name ON table_name(column1, column2);