Share via

Getting Information About Collations

  • Article

You can use the following catalog views and functions to obtain collation information in SQL Server 2005.

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 2005.

fn_helpcollations

Returns a list of available collations in SQL Server 2005.

See Also

Concepts

Working with Collations

Help and Information

Getting SQL Server 2005 Assistance