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 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 ??