title: SQL Server INFORMATION_SCHEMA.VIEW_COLUMN_USAGE not updated on table update
body: <p>I'm trying to learn more about SQL Server, and I came across something I don't understand.  I have a SQL Server 2008 database (the free version).  I have a view that I defined using a wildcard, like this:</p>
  
  <pre><code>Select * from ApplicantApplications
  </code></pre>
  
  <p>When I checked the system view "INFORMATION_SCHEMA.VIEW_COLUMN_USAGE", each of the columns from the view I defined were there.</p>
  
  <p>Later, I updated the ApplicantApplication table and added a field "TestValue"</p>
  
  <p>When I looked back at the system view "INFORMATION_SCHEMA.VIEW_COLUMN_USAGE", the new column that I added to the table was not there.  The view that I defined has the new column in it.</p>
  
  <p>Do I need to do something special to make that column appear in the system view?  I thought it would get updated automatically.</p>
  
  <p>Thanks!</p>