How can I change the collation of an existing view?

Is there a way to change the collation of a view?

JeffAAAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jorge_torizConnect With a Mentor Research & Development ManagerCommented:
There isn't another way to do it... unless changing the collation of your database
0
 
jorge_torizResearch & Development ManagerCommented:
CREATE VIEW GetProducts
AS
    SELECT ProductID, Name FROM Production.Product
GO
ALTER VIEW GetProducts
AS
    SELECT ProductID, Name COLLATE Modern_Spanish_CS_AS FROM Production.Product
0
 
JeffAAAuthor Commented:
This appears to alter the collation for the field [name]. I'm trying to change the collation for the entire view.
0
All Courses

From novice to tech pro — start learning today.