Does updating a view effects the table back | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
0

Does updating a view effects the table back

1st Nov 2018, 2:36 PM
SHAILA BHAGWAT
2 Answers
+ 2
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
1st Nov 2018, 4:32 PM
Ipang
0
Thanks
1st Nov 2018, 5:06 PM
SHAILA BHAGWAT