Sorry, I seem to have misread your e-mail. Now it would be:
DROP VIEW .. IF EXISTS CREATE OR REPLACE VIEW .. IF NOT EXISTS Best regards Andreas On Tue, 2022-07-05 at 02:50 -0700, prrvchr wrote: > Hi Andreas, > > The UNO API also provides an interface com.sun.star.sdbcx.XRename to > change the name of a view, but apparently this interface is not > implemented in Base because it is never called. > > But I don't want to rename the view but change its command, and I > can't find a command in H2 to do so. > Please advise me the best alternative. > > > Le mardi 5 juillet 2022 à 11:38:52 UTC+2, and...@manticore- > projects.com a écrit : > > Greetings! > > > > On Tue, 2022-07-05 at 02:36 -0700, prrvchr wrote: > > > What is the best alternative with H2? > > > > > > H2 has a really excellent > > documentation: https://www.h2database.com/html/commands.html > > > > Your are looking > > for: https://www.h2database.com/html/commands.html#alter_view_rename > > > > Best regards > > Andreas > -- > 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/81a629f4-f62f-4f34-beba-d478f52ce688n%40googlegroups.com > . -- 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/f5b765a084d99997bb9add81e7cc78e7bf6ebdcc.camel%40manticore-projects.com.
