Share via


Getting Information About Collations

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