Elson Vaz schrieb am 30.01.2018 um 14:40:
Hello!
I want make change in one view that have dependence view's, so when i try to
make change i'm block because of this, what is the best solution??
This can easily be dealt with when using a schema management tool.
We use Liquibase for this and the main migration script simply drops all views
before running any migration (so that table columns can be removed or renamed
without having to think about view dependencies).
Once the table migrations are done, all views are re-created automatically.
The Liquibase migration script and the SQL source for the views are stored
together in Git.
Thomas
