select
a.name 表名,b.name 列名
from
sysobjects a,syscolumns b
where
a.id
=
b.id
and
b.name
=
'
列名
'
and
a.type
=
'
U
'
转载于:https://www.cnblogs.com/zhangtao/archive/2010/04/24/1719338.html