Create Table dbo.TestTable (TestID int, TestValue varchar(5))
Go

Create Function dbo.TestTVF ()
Returns Table
As
Return (Select * From dbo.TestTable)
Go

Select *
From dbo.TestTVF();
Go

Alter Table dbo.TestTable Add TestValue2 varchar(5);
Go

Exec sp_refreshsqlmodule 'dbo.TestTVF';
go

Select *
From dbo.TestTVF();
Go