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
  • ankit murela
    Feb, 2018 17

    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'

    • 1
  • vijay reddy
    Nov, 2016 9

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

    • 1
  • vijay reddy
    Nov, 2016 9

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

    • 1
  • 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,

    • 1
  • Rupali Shinde
    Nov, 2015 27

    1) Yes 2) No Why ??

    • 1


Most Popular Job Functions


MOST LIKED QUESTIONS