How to change collation of a view

Today, my collegue asked me to change a filed collation from TaiWan to Latin1, I said he has dbo rights, why not change it by himself? He replied to me it is gray when he clicked the field from pop up property window. I noticed, yes, it is gray as thought as I am administrator. OK, to meet this problem, the good method is use script:

ALTER VIEW GetProducts
AS
    SELECT ProductID, Name COLLATE Modern_Spanish_CS_AS FROM Production.Product

转载于:https://www.cnblogs.com/sdikerdong/archive/2010/11/10/1873728.html