devxlogo

June 28, 2018

Finding Collations

To?find?Collations?in?your?table,?you?can?use?the?following: SELECT ????SysCol.Name,?SysCol.Collation_Name FROM? ????sys.Columns?SysCol WHERE ????Object_ID?=?OBJECT_ID(‘YOUR_TABLE_NAME’)