Cacher is the code snippet organizer for pro developers

use dbTest
go
select table_name, column_name, collation_name
 from information_schema.columns
 where table_name = 'RandomData'

 alter table RandomData alter column SomeVarchar Varchar(10) collate SQL_Latin1_General_CP1_CS_AS null

 alter table RandomData alter column SomeVarchar Varchar(10) collate Latin1_General_100_CS_AS_SC null