select a.name 表名
from sysobjects a,syscolumns b
where a.id=b.id and OBJECTPROPERTY(a.id, N'IsUserTable') = 1 and b.name='你的列名'
from sysobjects a,syscolumns b
where a.id=b.id and OBJECTPROPERTY(a.id, N'IsUserTable') = 1 and b.name='你的列名'
when 'U' then '用户表'
when 'S' then '系统表'
when 'V' then '视图'
when 'P' then '存储过程'
else '其他' end
,对象名=name
from 库名..sysobjects a
where exists(
select 1 from syscolumns
where id=a.id and name='列名')