title: Updatable views - SQL Server 2008
body: <p>A question about updatable db views: I'm reading through some MSDN documentation on the subject, and I come across the following restriction:</p>
  
  <blockquote>
    <p>Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table.</p>
  </blockquote>
  
  <p>I just want to be sure I understand the restriction. I'd like to use views in a couple of my media review projects. The relational data is spread throughout tables, but a view seems to be the best way to be able to consolidate the data I need from multiple tables (some of which are linked via foreign keys) into a centralized location. Since the columns would come from a variety of tables, does this mean I can't run one blanket INSERT or UPDATE to persist changes in all the columns?</p>