Tag Archives: SQL

If you for some reason needs to change the collation of a column in SQL Server to the default database collation, you can use the following syntax: ALTER TABLE <table_name> ALTER COLUMN <column_name> <current_data_type> COLLATE database_default Eg.: ALTER TABLE myTable … Continue reading →