title: How to rebuild view in SQL Server 2008
body: <p>There is a view in my DB that someone defined with a * from one table.  I just added a new column to that table and I want the view to reflect the new column.  Besides re-executing the view creation script, is there another way to rebuild the view?  I am looking for something similar to how <strong>sp_recompile</strong> will recompile a stored procedure (or more accurately flag it to be compiled next time it is called).</p>
  
  <p><strong>Update:</strong> On a long shot I tried calling sp_recompile on the view and while the call worked, it didn't rebuild the view.</p>
  
  <p><strong>Update 2:</strong> I would like to be able to do this from a script.  So the script that adds the columns to the table could also update the view.  So like I said, something similar to sp_recompile.</p>