Get db-wide columns info

script.sql

select 
    schema_name(tab.schema_id) as schema_name,
    tab.name as table_name, 
    --col.column_id,
    col.name as column_name, 
	col.is_nullable,
    t.name as data_type,
    col.precision,
	col.scale
from sys.tables as tab
    inner join sys.columns as col
        on tab.object_id = col.object_id
    left join sys.types as t
        on col.user_type_id = t.user_type_id
order by 
    schema_name,
    table_name, 
    column_id;