select s.name
from sysobjects s
inner join sys.schemas c on c.schema_id = s.uid
inner join syscolumns l on l.id = s.id
where l.name like '%produc%key%'
Scripts, Articles, Relevant for DBAs, Consultants, BI, Data Scientists and Developers
select s.name
from sysobjects s
inner join sys.schemas c on c.schema_id = s.uid
inner join syscolumns l on l.id = s.id
where l.name like '%produc%key%'