How to recompile the view??

• Ezhilan

  Ten Centuries

  Points: 1319

  More actions

  July 25, 2007 at 7:03 am

  #120884

  Hi,

  How to refresh the view automatically, when the table to which it depends got altered.

  That is, if we are adding a new column in the table, then it should be reflected in the view automatically. How to do that?

  Example:

  Create table Check_Table

  (

  col1 varchar,

  col2 varchar

  )

  create view Check_Table_VW as

  select * from Check_Table

  If we are adding one more column 'Col3', then it should be reflected in the view if you go for

  select * from Check_Table_VW

  How to do this with out dropping and recreating the View?

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  July 25, 2007 at 7:25 am

  #722269

  Try this: exec sp_refreshview @viewname = 'name of view'

  

• Ezhilan

  Ten Centuries

  Points: 1319

  More actions

  July 25, 2007 at 7:49 am

  #722282

  Thanks...its working fine..