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 - 4 of 4 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

abinay

  • 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

vitalreddy

  • 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

asifeqbal

  • 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

Ayushi

  • 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