magritton
6/25/2015 - 8:16 PM

Get the column collation from a table

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