Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to refresh user-defined functions [duplicate]

Tags:

sql

sql-server

Possible Duplicate:
SQL Server UDF refresh

The system stored procedure sp_refreshview can be used to validate and recompile views in SQL Server.

How can I do the same for scalar functions and table functions?

like image 305
Anthony Faull Avatar asked Aug 17 '26 06:08

Anthony Faull


1 Answers

You should look at sp_refreshsqlmodule.

like image 102
Aaron Bertrand Avatar answered Aug 18 '26 18:08

Aaron Bertrand



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!