Does updating a view effects the table back

Answer 1

If you meant SQL views, then first understand, to be clear you should have 'SQL' in your original post "Relevant Tags" section. Lack of description regarding a question lessen your chance for good response.

Updating data through views is possible, though it can be tricky, as there are some restrictions to follow, before a view can be used to update the underlying table. Personally, if possible, I would prefer to update to the table directly.

If you must however, go the views way for updating your table data, then you can see on the following link, the numerous complicated restrictions imposed for update-able views. Mind that the article specifically refer to MSSQL, and that it is possible other DBMS has other different rules.

http://www.informit.com/articles/article.aspx?p=130855&seqNum=4

Answer 2

Thanks