sp_recompile does not recompile inline TVF. What alternatives are there other than using an ALTER statement?
Using SELECT * in production code is evil, for a number of reasons.

If you absolutely must do this, the procedure you're looking for is sp_refreshsqlmodule, which works much like the built in sp_refreshview, rather than sp_recompile.