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: 
  1. SELECT DATABASEPROPERTYEX('Database_Name''Collation'AS Collation_Name;   
Example:
 
 
Ebook Download
View all
Learn
View all