Friday, August 26, 2011

How to Alter View / Table Function dynamically in sql server

How to Alter View / Table Function dynamically in sql server

Question :

Hi friends,



[ SQL SERVER 2008 ]



 I'm using UDDs ( User Defined DataType ) for my tables and created lot of views. Same UDD would refer muliple tables..


Now i changed my UDD in table by increasing size but its not reflecting in View.  if i alter that view then its reflecting..


so altering each view and table function manually is very difficult..


Answer :

              EXEC sp_refreshsqlmodule @View_Name/@Function_Name 


 

No comments:

Post a Comment