SQL Server Transact Basic to Expert - View Collation Metadata (for database)

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

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