Change Database or Column Collation
To change the collation of a single database
ALTER DATABASE db_name
COLLATE SQL_Latin1_General_CP1_CI_AS;
GO
ALTER TABLE db_name..table_name ALTER COLUMN column_name VARCHAR(10) COLLATE SQL_Latin1_General_CP1_CI_AS;
GO
ALTER DATABASE db_name
COLLATE SQL_Latin1_General_CP1_CI_AS;
GO
ALTER TABLE db_name..table_name ALTER COLUMN column_name VARCHAR(10) COLLATE SQL_Latin1_General_CP1_CI_AS;
GO
Comments
Write the first comment
Leave a trace
Post being viewed right now
