H2: how to tell if index exists?

Question

I can use CREATE TABLE IF NOT EXISTS to create a table only if it doesn't exist.

How can i do the same for CREATE INDEX.. to only create it if it doesn't exist?

Answer 1

You can do it as follows,

CREATE INDEX IF NOT EXISTS NEW_INDEX_NAME ON TABLE_NAME;

You can follow link aswell, http://www.h2database.com/html/grammar.html#create_index