Getting Information About Collations

You can use the following catalog views and functions to obtain collation information.

Catalog view	Description
sys.databases	Returns information about the collation of a database.
sys.columns	Returns information about the collation of a column of a table or view.
COLLATIONPROPERTY	Returns information about collations in SQL Server.
fn_helpcollations	Returns a list of available collations in SQL Server.

Note

Collations marked for deprecation in SQL Server 2008 or future versions of SQL Server are not included in the list of available collations returned by fn_helpcollations. For more information about deprecated collations in SQL Server 2008, see Deprecated Database Engine Features in SQL Server 2008 R2.

See Also

Concepts

Working with Collations