Home >Database >Mysql Tutorial >查找数据库中含有某字段的所有表
查找数据库中含有某字段的所有表
- WBOYOriginal
- 2016-06-07 15:48:161479browse
-- 含有医院编号字段的所有表 select a . [name] 表名 from sysobjects a , ( select [id] , count (*) b from syscolumns where [name] = 'HospitalId' group by [id] ) b where a . [id] = b . [id] -- 同时含有医院编号和科室编号字段的所有表 select a .
--含有医院编号字段的所有表
select a.[name] 表名from sysobjects a,
(
select [id],count(*) b from syscolumns
where [name] ='HospitalId'
group by [id]
)
b where a.[id]=b.[id]
--同时含有医院编号和科室编号字段的所有表
select a.[name] 表名from sysobjects a
left join
(
select [id],count(*) b from syscolumns where [name]
in('HospitalId','DepartmentId') group by [id] having count(*)>1
) b
on a.[id]=b.[id]
where b.id is not null
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：软考之下午题做题技巧Next article：PowerDesigner实用技巧小结(4)