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')
Visit the DevX Tip Bank