Register now or log in to join your professional community.
Yes, views can be updated if they are built on only one table and fulfill following conditions:
Possible based on this condition : A View can be updated/deleted/inserted if it has only one base table if the view is based on columns from one or more tables then insert, update and delete is not possible.
We can update a view by using insert,update,delete statements.
A view from a single table can be updated where as a view from multiple tables can not be updated.
If you update a view you will actually be updating the underlying table. A view is nothing physical, just a representation of the data underneath it.
The data "in" a view has no existence independent from the tables that make up the view. The view is actually a stored SELECT statement that is presented as a table. The data is stored in the original tables and only "assembled" into the view when you want to look at it. If the view is update-able (not all views are) the updates are applied to the table data.
yes we can update View .
UPDATE View Name SET Colum Name = 'Name'
possible to update a view if it was created from one base table. otherwis not possible to update a view.
When modifying data through a view, using INSERT or UPDATE statements, certain limitations exist depending upon the type of view. Views that access multiple tables can only modify one of the tables in the view.
yes , update (view name) set insert data or the condition where any field
Yes,
View is dependant on the logic you have applied in respective model ,controller or action . You can update it there if it does not brake other things (i.e. data remains consistent).
It is not possible to update view. Because the original data exists in table not in view DML operations like Insert, Update, Delete are not possible
