We have views created with SCHEMABINDING
and they are used in other views that also have SCHEMABINDING
I want to alter the base view to include newly added columns of the table but it is not allowing to alter it saying that other views are dependent of this view.
Can we alter view without schemabinding and after change later alter it again to apply schemabinding?
Does it work like that?