sql中如何知道字段在哪个表里?

Question

如题所述

Answer 1

下边是SQLSERVER中查询某字段在哪些表中含有的语法：
select sysobjects.name from syscolumns inner join sysobjects on syscolumns.id = sysobjects.id and sysobjects.xtype = 'u' where syscolumns.name = '字段名字'

Answer 2

数据库不同，查找方法不同
以下是sqlserver的，oracle的自己上网找下，也挺快的
Select *
From sysobjects s
Where Exists(
Select *
From syscolumns
Where ID = s.ID and name like '%user%'
)

参考资料：http://apps.hi.baidu.com/share/detail/33237798

Answer 3

一句话 搞定
select [name] from sysobjects where id in(select id from syscolumns Where name='字段名')

Answer 4

需求不明确 说具体点