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