hi, >> Modify a view It's not a use case, it's a routine maintenance task. >> > I will add a feature request for "Drop with invalidate views (so that > source code is not lost). ok, thanks. > Check what other databases do exactly. > The sentence CREATE OR REPLACE VIEW ala PgSql, it's my preferred way , with a big DDL generation convenience.
http://www.postgresql.org/docs/8.1/static/sql-createview.html http://www.postgresql.org/docs/8.1/static/sql-dropview.html http://www.postgresql.org/docs/8.1/static/sql-createview.html > However I suggest you have a copy of the view source code stored > somewhere outside the database Yes I going to define a table in the database to store the view source ;-) regards, Dario -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
