SQL Server UDF refresh

I have altered the column datatype in one of my tables from int to decimal.

I have a UDF referencing the columns of this table.

How can I ensure my UDF 开发者_JAVA技巧returns decimals rather than int without having to re-create it?

(For view, I know we can use sp_refreshview, not sure about UDF).

Thanks, Rashmi

I assume you are talking about an inline TVF in which case you can use

EXEC sp_refreshsqlmodule 'YourTVF'