Solved

How can I change the collation of an existing view?

Posted on 2008-10-15
3
1,704 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
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.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

910 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now