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
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