This topic has not yet been rated - Rate this topic

Getting Information About Collations

SQL Server 2008

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.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions