Helps you find the columns of a table and the data types

SqlServer_ColumnTypes.sql

SELECT 
    c.name 'Column Name',
    t.Name 'Data type',
    c.max_length 'Max Length',
    c.precision ,
    c.scale ,
    c.is_nullable
FROM    
    sys.columns c
INNER JOIN 
    sys.types t ON c.user_type_id = t.user_type_id
WHERE 
	c.object_id = OBJECT_ID('TABLE_NAME')