use [YourDB]
Select t.name      UDT,
       o.name      Object,
       o.type_desc ObjectType,
       c.name      AttributeName,
       c.type_desc AttributeType
From   (
        SELECT object_id, name, user_type_id, 'SQL_COLUMN' AS type_desc
        FROM sys.columns
     
        UNION ALL
        
        SELECT object_id, name, user_type_id, 'SQL_PROCEDURE_PARAMETER'
        FROM sys.parameters
       ) c
       JOIN sys.objects o ON o.object_id    = c.object_id
       JOIN sys.types   t ON t.user_type_id = c.user_type_id
Where  t.schema_id = 1			-- dbo (see sys.schemas for all other object owners & change as reqd)
order by
       UDT,
       Object

use [YourDB]
Select t.name      UDT,
       o.name      Object,
       t.xusertype ObjectType,
       c.name      AttributeName,
       
       case o.xtype
       when 'P'
       then 'SQL_PROCEDURE_PARAMETER'
       else 'SQL_COLUMN'
       end         AttributeType
       
From        syscolumns  c
       JOIN sysobjects  o ON o.id       = c.id
       JOIN systypes    t ON t.usertype = c.xusertype
Where  t.uid = 1			-- dbo (see sysusers for other users' IDs)
and    o.xtype in ('P','U')
order by
       UDT,
       Object