Re: Alter view with dependence without drop view!

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,
whatis 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
tablecolumns 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