[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1717
  • Last Modified:

How can I change the collation of an existing view?

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

0
JeffAA
Asked:
JeffAA
  • 2
1 Solution
 
jorge_torizCommented:
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
 
jorge_torizCommented:
There isn't another way to do it... unless changing the collation of your database
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now