SQL Server 2008 R2- Find Database Collation

How to find collation of current database?

There are two different ways to find out SQL Server database collation.

Using T-SQL

 SELECT DATABASEPROPERTYEX('Database_Name', 'Collation') as SQLCollation;

Using SQL Server Management Studio (SSMS)

• Right Click on the database
• Go to Properties

You will get the dialog box as shown in the figure

 

You can execute the system function fn_helpcollations to retrieve a list of all the valid collation names for Windows collations and SQL Server collations:

SELECT * FROM fn_helpcollations()

Note:

For demo showing the properties window of tempdb. Similarly you can check on the desired database.