查询某个字段属于哪些表

use test
---建表
CREATE TABLE TEST(oliver varchar(100))
-------查询SQL
Select a.name as 字段名, b.name as 表名 from syscolumns a
left join sysobjects b on a.id = b.id
Where b.type = 'U' and a.name ='oliver' order by b.name