SQL - How to alter collation on an existing view

Question

I have an existing view. I need to change the collation on one of the columns in the view. How can I achieve this using T-SQL? Thanks in advance.

Answer 1

Something like this:

Alter View YourViewName
AS
Select Yourcolumn Whatever_collation_you_need
from YourTable 

Also, if you need to link your view with another table or view, you could just specify the collation like this, with no need to alter your view:

select
*
from v_Filiales f --> this is a view
inner join t_Persona p --> this is a table
on p.cPerCodigo = f.cPerJuridica COLLATE Latin1_General_CI_AS