select objs.name as TableName, cols.name as ColName
From sysobjects objs inner join syscolumns cols on (objs.id=cols.id)
where objs.xtype='U' and cols.name='字段名'
select objs.name as TableName, cols.name as ColName
From sysobjects objs inner join syscolumns cols on (objs.id=cols.id)
where objs.xtype='U' and cols.name='字段名'