数据库查找 哪些表存在某个字段

SELECT b.name as TableName,a.name as columnname
From syscolumns a
INNER JOIN sysobjects b ON a.id=b.id
where b.type='U'
AND a.name like 'store%'

原文地址:https://www.cnblogs.com/zxs-onestar/p/7804972.html