View Collation Information

You can view the collation of a server, database, or column in SQL Server Management Studio

using Object Explorer menu options or by using Transact-SQL.

You can use one of the following:

Management Studio

Transact-SQL

1. In Object Explorer, connect to an instance of Database Engine.

2. Right-click the instance and select.

3. In Object Explorer, connect to an instance of Database Engine and then expand that

instance.

2. Expand

, right-click the database and select.

1. In Object Explorer, connect to an instance of Database Engine and then expand that

instance.

2. Expand

, expand the database and then expand.

3. Expand the table that contains the column and then expand.

4. Right-click the column and select. If the collation property is empty, the

column is not a character data type.