select db_name() as 'DatabaseName',
ss.name+'.'+so.name as ObjectName,
so.type_desc as ObjectType,
sc.name as ColumnName

,case
    when st.name IN ('char','varchar') then st.name+'('+case when sc.max_length<0 then 'MAX' else convert(varchar(10),sc.max_length) END+')'
    when