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

10y

1.1k

No it will not update both the tables. it will update only one table.

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

10y