create if not exists view?

Question

Is there any way to create view if not exists in MySQL or H2 Database?

user_4606907 · Answer

On H2 you can add IF NOT EXISTS before the view name you want to create. e.g.:

CREATE VIEW IF NOT EXISTS viewExampleName (column1, column2) 
AS ( 
    SELECT column1, column2
    FROM example_table 
);