devxlogo

Finding Collations

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’)

devx-admin

Share the Post: