ARE VIEWS UPDATEABLE ?

Mahesh Rawat

Total Post:138

Points:690
Posted by  Mahesh Rawat
DB2 
DB2
 1421  View(s)
Ratings:
Rate this:
  1. Mahesh Rawat

    Post:138

    Points:690
    Are views updateable ?

    Not all of them. Some views are updateable e.g. single table view with all the fields or mandatory fields. Examples of non-updateable views are views which are joins, views that contain aggregate functions(such as MIN), and views that have GROUP BY clause.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!