• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7. Working with SQL Server Views > Modifying Data in a View

Modifying Data in a View

With a few exceptions, the results of views are updateable. Recognize that a view is not a table and does not contain any data. Therefore, when you are modifying the data in a view, you are modifying the underlying table. You cannot violate any rules, check constraints, referential integrity rules, or any other rules that govern the data that can be contained in the tables. The following are limitations to the updateability of a view:

  • If a view joins multiple tables, you can insert and update data in only one table at a time in the view result.

  • The results of a view that aggregates data are not updateable.

  • The results of a view that unions data without the UNION ALL clause are not updateable.

  • The results of a view that contains a DISTINCT statement are not updateable.

  • Text and image columns cannot be updated via a view.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint