SQL Management Studio - Add-on / Extension to view Column Data Type
This is standard functionality of SSMS (and has been for a while, I tested in both SSMS 2014 and SSMS 17.2).

For example when you hover over a column the tooltip shows you the data type:



The intellisense autocomplete also shows the data type when you select a column with your up/down arrows: