Solved

How can I change the collation of an existing view?

Posted on 2008-10-15
3
1,708 Views
Last Modified: 2008-10-19
Is there a way to change the collation of a view?

0
Comment
Question by:JeffAA
  • 2
3 Comments
 
LVL 15

Expert Comment

by:jorge_toriz
ID: 22725104
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
 

Author Comment

by:JeffAA
ID: 22725228
This appears to alter the collation for the field [name]. I'm trying to change the collation for the entire view.
0
 
LVL 15

Accepted Solution

by:
jorge_toriz earned 250 total points
ID: 22726562
There isn't another way to do it... unless changing the collation of your database
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question