Post

Get Collation Name for Column Name in SQL Server

551
0
0

Below code retrieve the collation name of columns for a table.

Code:

SELECT name AS Column_Name, collation_name
FROM sys.columns
WHERE OBJECT_ID = (SELECT OBJECT_ID
FROM sys.objects
o WHERE o.type='U' AND name = 'Table_Name')