Can i update views in SQL

Can i update views in SQL if yes in what scenarios?
if your view is joining multiple tables

Questions by rahul.solanke

Showing Answers 1 - 7 of 7 Answers

Jean Daniel Joseph

  • Jan 17th, 2012

Yes but you remember views, represents a virtual table but if you delete the table you wont be able to update the view


  • Oct 6th, 2012

yes,we can update the view as like a table.view is virtual table,basically it is not having any storage data. in a view data will be coming from table.if u delete the table .we wont update the view.

  Was this answer useful?  Yes


  • Nov 10th, 2014

We can update only on simple view ,,if we want to update view on multiple tables (complex view) it wont work properly(it will give some wrong updates) so to avoid this we used "instead of triggers"

  Was this answer useful?  Yes


  • Mar 18th, 2015

Yes, we can update view when view is created by single table (simple view). If we want to Update view that are based on multiple tables using Joins, Update does not work. So we used "Instead of Triggers" for updating Complex view.

  Was this answer useful?  Yes


  • May 7th, 2015

We can update simple views(having data from one table) and complex views(having data from multiple tables) but columns should be taken from one base table for update.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions