title: Delete a record from a view and from all its related tables
body: <p>I am using SQL server Management studio 2008.</p>
  
  <p>I want to delete a single record from one of a view which shows null values in that record for all columns.</p>
  
  <p>I can't get to know,from which table i get this null record.</p>
  
  <p>I checked all the tables which are joined for the view but none of the tables contains null record.</p>
  
  <p>Can anyone help me to delete this null record from my view and from all related tables..?</p>
  
  <p>Because I am using this view in many other pages and it creates error in each page with null value.</p>
  
  <p>when i try to delete this record from view it shows error like</p>
  
  <pre><code>"Msg 4405, Level 16, State 1, Line 1
  View or function 'viewGetProgressOverview' is not updatable because the modification affects multiple base tables."
  </code></pre>