SQL View is formed by joins of two table. if we modify view by some query , can corresponding records from both table are getting updated ?
Rupali Shinde
No it will not update in both the table.Only one table will be update Create View asp_vwAS (Select h.First_name,h.salary,A.first_name as Test,A.date_of_birth from honey h left join ashu A on h.first_name=A.first_name)Select * from asp_vw Update asp_vw set first_name = 'parkash1'
No it will not update both the tables. it will update only one table.
Yes It will be Updated .If you did not have WITH CHECK OPTION defined in View, the UPDATE statement would succeed,
1) Yes 2) No Why ??