Is change in view affect the DB

Changing means altering the view or updating the view?

If altering the view then i think there is no affect in database as we are altering select statement.If updating then Yes this will affect database.

Hi,

 

Updating a view will results in updating the abse table. Please follow below articles for details -

 

http://www.informit.com/articles/article.aspx?p=130855&seqNum=4

 

https://www.w3resource.com/sql/update-views/sql-update-views.php

 

https://stackoverflow.com/questions/2648445/if-i-update-a-view-will-my-original-tables-get-updated 

Hi Riya,

 

Yes, 

see Using Views in Microsoft SQL Server 

 

If you satisfied then accept this solution