SQL Server: sys.syscolumns

select
   sch.name             sch_name,
   obj.name             obj_name,
   obj.type_desc,
   col.name             col_name,
   typ.name
from
   sys.schemas      sch                                           join
   sys.all_objects  obj on sch.schema_id      = obj.schema_id     join
   sys.syscolumns   col on obj.object_id      = col.id            join
   sys.types        typ on col.xtype          = typ.user_type_id
where
   col.name like '%sid'
order by
   sch.name,
   obj.name