Check Collation Name of Columns in Database

Hey Friends just simply execute the below query within your database, it will show table name,column name and collation name.

QUERY :

SELECT [TABLE_NAME] = OBJECT_NAME([id]),
[COLUMN_NAME] = [name],
[COLLATION_NAME] = collation
FROM syscolumns
WHERE collation <> ‘your_database_collation_type’
AND collation IS NOT NULL
AND OBJECTPROPERTY([id], N’IsUserTable’)=1

OUTPUT :

Collation
List of Database Tables Name with their fields and Collation Name

 

Posts Tagged with…

Write a Comment

Your email address will not be published. Required fields are marked *