All operations performed on a view actually affect the base table of the view.
You can use views in almost the same way as tables.
, a series designed to support a new career or lifelong journey in IT.
This installment is devoted to data: getting it into and out of tables and databases.
I'm starting to think that it was just something the senior Devs/DBAs would say because they didn't feel like explaining to be careful about updating through views (IE inner vs outer join) triggers "SQL Server must be able to unambiguously trace modifications from the view definition to one base table.".
There is no performance disadvantage to Updating these Views as SQL Server will just generate a query plan for the base table affected.
But if the question is "Can you update data in the underlying table through view? SQL Server will allow you to update data in the underlying table through a view.Views are very powerful because they allow you to tailor the presentation of data to different types of users.When a view is created, Oracle Database expands any wildcard (*) in a top-level view query into a column list.You can use this example as a guide for customizing update property settings on a view.Updating Multiple Tables in a View CREATE SQL VIEW emp_cust_view AS ; SELECT employee.emp_id, ; employee.phone, customer.cust_id, ; customer.emp_id, customer.contact, ; customer.company ; FROM employee, customer ; WHERE employee.emp_id = customer.emp_id DBSETPROP('emp_cust_view.emp_id', 'Field', ; 'Update Name', 'employee.emp_id') DBSETPROP('emp_cust_view.phone', 'Field', ; 'Update Name', 'employee.phone') DBSETPROP('emp_cust_view.cust_id', 'Field', ; 'Update Name', 'customer.cust_id') DBSETPROP('emp_cust_view.emp_id1', 'Field', ; 'Update Name', 'customer.emp_id') DBSETPROP('emp_cust_view.contact', 'Field', ; 'Update Name', 'customer.contact') DBSETPROP('emp_cust_view.company', 'Field', ; 'Update Name', 'customer.company') The data dictionary features for views are similar in function to their counterparts for database tables.Where there/Are there significant performance implications to doing this?