Get Collation for a table in Sql server

SQL to get Collation for a table in Sql server

SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'EMPLOYEE'