Change collation for views

SQL Server Administration
1

Hi all,

I'm changing the collation for all columns in my database to Latin1_General_CI_AS. I did this by running a number of ALTER TABLE ALTER COLUMN commands

After I do this, what do I need to do with the views?

Do I just need to drop the views and recreate them or do I need to run ALTER VIEW statements?

Thanks,

Ranvir

2

You can run sp_refreshview