Find Collation of a SQL Server Database and Table Column

Find Collation of a SQL Server Database using SQL Server Management Studio (SSMS):
Right Click on a database in Object Explorer -> Click 'Properties' -> 'Options':

database_collation_properties_ssms

Find Collation of a SQL Server Database using T-SQL:

SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation')
GO

database_collation_tsql

Find Collation of a SQL Server Table Column using SQL Server Management Studio (SSMS):

Right Click on a table in Object Explorer -> Click 'Design':

table_column_design_ssms

Click on a column and see it's collation:

table_column_collation_ssms

Find Collation of a SQL Server Table Column using T-SQL:

USE AdventureWorks
GO
Select TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME, DATA_TYPE
From INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = 'Person'
AND TABLE_NAME = 'Address'
AND COLUMN_NAME = 'AddressLine1'

table_column_collation_2_tsql

If the post helped you, please share it:
Pin It

3 comments to Find Collation of a SQL Server Database and Table Column

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">