Can we update views.If not,why?

  • Interview Candidate
  • 31
  • 42679

Showing Answers 1 - 31 of 31 Answers

Tapas

  • May 4th, 2006
 

No,

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

  Was this answer useful?  Yes

chandu

  • May 4th, 2006
 

Hi,

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

swathi

  • 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

Pritpal

  • 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

Apprentice

  • 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. 

saurabh

  • 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

sridhar

  • Oct 18th, 2006
 

can we update the view.If not why?

  Was this answer useful?  Yes

rajithrnair

  • 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

nipun

  • 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

AjitKshirsagar

  • 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

PADMINI M

  • 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