This blgo shows how to check the collation details for a database level

Syntax:
SELECT DATABASEPROPERTYEX ( 'AdventureWorks' , 'Collation' )