Can we update views.If not,why?

Showing Answers 1 - 17 of 17 Answers


  • May 4th, 2006


View is not an independent thing where the data can be stored. View is a part of a table .

  Was this answer useful?  Yes


  • May 4th, 2006


we can update view .if the view is created with one table.

But we canot update view if the view is created with more than one table with multiple columns.why because view is single virtual table created multiple columns from diffrent tables. so we canot update this virtual table i.e view.when we selected multiple tables and mutiple columns.

  Was this answer useful?  Yes


  • May 30th, 2006

ya we can do...

  Was this answer useful?  Yes

nav dev

  • Jun 1st, 2006

yes views can be updated only if all elements of view are subset of the base table.suppose base table is having empid, name and addr colmns, then a view on this table created as

create view myview as select * from emp; only these type of views are updatable.

create view myview as select name,addr from emp; is not updatable.

  Was this answer useful?  Yes

Viswanathan Balaji

  • Jul 6th, 2006

Yes, Views are updatable based on conditions , it can be a single table having unique records based on primary key values or it can be multiple table linked with primary key values where updation of view should yield a unque recordset from the two tables .

Thanks and Regards,

Viswanathan Balaji

  Was this answer useful?  Yes


  • Jul 14th, 2006

Hi,we cannot update view, but we can create or replace a view. we cannot update its defination. we can update a underlying base table through a view under certain conditions i.e. only one table based view, no grouping, etc.

  Was this answer useful?  Yes


  • Sep 18th, 2006

First of all a view is not part of a table as a gentleman here explained. A view is a "virtual table", meaning it does not exist as a table. Yes, a view is an schema object but it is only as such, "view". It is a view of a table ot joined tables. If you are updating a "field" from a view, you are not updating the view but the table which that view is based upon. No you cannot update a view, only the table a view is based upon. 


  • Sep 28th, 2006

v can update view if and only the view is updatedable view. but the normal view cant be updated

  Was this answer useful?  Yes


  • Oct 18th, 2006

can we update the view.If not why?

  Was this answer useful?  Yes


  • Oct 31st, 2006

if the view is created using joins, group by statements we cannot update otherwise we can update the view

  Was this answer useful?  Yes

naresh kotapati

  • Jul 24th, 2014

view is like a logical table we can update view only if single table exist we cannot update view if multiple columns exist

  Was this answer useful?  Yes


  • Feb 2nd, 2015

View is basically like SQL table only , id used where the users has limited access to Table and it occupies less space compared to table

  Was this answer useful?  Yes


  • Mar 22nd, 2015

Views are virtual tables which contains query not data and it retrieves data based on the queries when used.
As it doesnt stores data physically so, we cant modify the data.

  Was this answer useful?  Yes


  • Nov 16th, 2015

Correct answer is it depends.
Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table
Only we can update a view in one base table.

  Was this answer useful?  Yes

amir ali

  • Nov 23rd, 2015

Views are dependent on data tables.

  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