query to get the datatypes for each column

tables-columns-datatypes.sql

SELECT  
    s.name AS SchemaName, 
    t.name AS TableName, 
    c.name AS ColumnName, 
    ty.name AS DataType, 
    c.max_length, 
    c.precision, 
    c.scale, 
    c.is_nullable 
FROM sys.tables t 
JOIN sys.schemas s ON t.schema_id = s.schema_id 
JOIN sys.columns c ON t.object_id = c.object_id 
JOIN sys.types ty ON c.user_type_id = ty.user_type_id 
ORDER BY  
    s.name, 
    t.name, 
    c.column_id;