I think it would be a big plus to have the ability to modify a view resolving automatically all its dependencies (i.e. dropping every dependent view, modifying the current one and then recreating all the dropped view in the right order). Most DBS, like PostgreSql, have transactional DDL, so the operation should not be dangerous if something goes wrong during the drop-create phase.
1 Comment
Ulf Weiland
said
about 3 years ago
Thanks for the suggestion. I will add this as an improvement request
Roberto Pellagatti
I think it would be a big plus to have the ability to modify a view resolving automatically all its dependencies (i.e. dropping every dependent view, modifying the current one and then recreating all the dropped view in the right order). Most DBS, like PostgreSql, have transactional DDL, so the operation should not be dangerous if something goes wrong during the drop-create phase.