Get Database Collation using T-SQL

In this blog we learn how to find the collation of a database using the T-SQL . Use the following command to find out the collation information of a database.

 

Syntax: 

SELECT DATABASEPROPERTYEX('Database_Name', 'Collation') AS Collation_Name;

Example: