Create View with Collation

726 Views Asked by At

I need to create a view from another database (linked as connectionserver) but here I need a different collation.

Example:

CREATE VIEW vw_table1
AS
SELECT *
FROM server2.table1;

How can I specify the collation by using this script?

Thanks in advance

0

There are 0 best solutions below