Hello! The SQL Standard doesn't have any commands for view modification, so the only portable way is to drop an old view and create a new one.
In H2 you can use CREATE OR REPLACE VIEW viewName AS … https://h2database.com/html/commands.html#create_view -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/6b7abe0b-8ebd-485a-885a-8b780a226c39n%40googlegroups.com.
