#fn_helpcollations()

[gaurava16fc]

T-SQL inbuilt function to retrieve all the supported collations within SQL Server

T-SQL inbuilt function to retrieve all the supported collations within SQL Server

Hi Friends,

Hope, you are doing fine!

Today, we will see the demo of T-SQL in-built TVF (Table Valued Function) function “fn_helpcollations()” which help us to retrieve all the supported collations within SQL Server.

Please refer the below link for your reference:

https://msdn.microsoft.com/en-us/library/ms187963.aspx

Syntax:

fn_helpcollations()

T-SQL:

SELECT * FROM fn_helpcollations()

Snapshot:

[varindersandhu-blog]

New Post has been published on Varinder Sandhu 's Blog

New Post has been published on http://www.varindersandhu.in/2012/03/19/sql-server-2008-r2-find-database-collation/

SQL Server 2008 R2- Find Database Collation

How to find collation of current database?

<!-- google_ad_client = "pub-2404605494811633"; google_alternate_color = "FFFFFF"; google_ad_width = 468; google_ad_height = 60; google_ad_format = "468x60_as"; google_ad_type = "text_image"; google_ad_channel =""; google_color_border = "FFFFFF"; google_color_link = "0000FF"; google_color_bg = "FFFFFF"; google_color_text = "000000"; google_color_url = "008000"; google_ui_features = "rc:6"; //-->

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

  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.