How to alter a view with SCHEMABINDING when other views are dependent on it

848 Views Asked by At

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?

0

There are 0 best solutions below