Dela via

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