Displaying Collations

Obtain the currently used collation.

Type the following command at the command prompt:
SELECT * FROM SYS.SYSCOLLATION
Parent topic: Understanding Collations