資料庫更改欄位時,可以刷新相關的VIEW

USE AdventureWorks; //資料庫名稱
GO
SELECT DISTINCT 'EXEC sp_refreshview ''' + name + ''''
FROM sys.objects so INNER JOIN sys.sql_dependencies sd
ON so.object_id = sd.object_id
WHERE type = 'V'
AND sd.referenced_major_id = object_id('Person.Contact') //Person.Contact 是資料表名稱