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: