create if not exists view?

Question

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

Answer 1

From section 12.1.12. CREATE VIEW Syntax of the MySQL 5.0 Reference Manual:

CREATE VIEW Syntax  CREATE     [OR REPLACE]     [ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]     [DEFINER = { user | CURRENT_USER }]     [SQL SECURITY { DEFINER | INVOKER }]     VIEW view_name [(column_list)]     AS select_statement     [WITH [CASCADED | LOCAL] CHECK OPTION] 

The CREATE VIEW statement creates a new view, or replaces an existing one if the OR REPLACE clause is given. This statement was added in MySQL 5.0.1. If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE VIEW. If the view does exist, CREATE OR REPLACE VIEW is the same as ALTER VIEW.