Find the column level collation using t-sql

select object_name(object_id)as Tablename,name as Column_Name, collation_name from sys.columns