SQL Server 2008 R2- Find Database Collation

SQL, SQL-Advanced, SQL-Tips and Tricks, Varinder Sandhu

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

Find Database Collation

Find Database Collation

 

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.

Related Posts

,