Refreshing metadata on user functions t-SQL

Posted by luckyluke on Stack Overflow See other posts from Stack Overflow or by luckyluke
Published on 2010-03-16T13:42:32Z Indexed on 2010/03/16 13:46 UTC
Read the original article Hit count: 293

Filed under:
|
|

I am doing some T-SQL programming and I have some Views defines on my database. The data model is still changing these days and I have some table functions defined. Sometimes i deliberately use

 select * from MYVIEW

in such a table function to return all columns. If the view changes (or table) the function crashes and I need to recompile it. I know it is in general good thing so that it prevents from hell lotta errors but still...

Is there a way to write such functions so the dont' blow up in my face everytime I change something on the underlying table? Or maybe I am doing something completely wrong...

Thanks for help

© Stack Overflow or respective owner

Related posts about tsql

Related posts about sqlserver-2008