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