如何在数据库里找到含有相同字段的表?

1、查已知列名的情况:
SELECT b.name as TableName,a.name as columnname
From syscolumns a INNER JOIN sysobjects b
ON a.id=b.id
AND b.type='U'
AND a.name='你的字段名字'

---------------------------------------------------------------
2、未知列名查所有在不同表出现过的列名:
Select o.name As tablename,s1.name As columnname
From syscolumns s1, sysobjects o
Where s1.id = o.id
And o.type = 'U'
And Exists (
Select 1 From syscolumns s2
Where s1.name = s2.name
And s1.id <> s2.id
)

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus