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

[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: