Get the column collation from a table
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