Is change in view affect the DB

Question

Does a change in view affect the original database?

Manish Kumar · Answer

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.

Midhun T P · Answer

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

Nilesh Patil · Answer

Hi Riya Yes see Using Views in Microsoft SQL Server If you satisfied then accept this solution