Rupali Shinde
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 ?
By Rupali Shinde in Databases & DBA on Nov 27 2015
  • vijay reddy
    Nov, 2016 9

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

    • 0
  • vijay reddy
    Nov, 2016 9

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

    • 0
  • Ashutosh Tripathi
    Mar, 2016 10

    Yes It will be Updated .If you did not have WITH CHECK OPTION defined in View, the UPDATE statement would succeed,

    • 0
  • Rupali Shinde
    Nov, 2015 27

    1) Yes 2) No Why ??

    • 0