use 数据库名 go select a.Name as tableName from sysobjects a inner join syscolumns b on a.ID=b.ID where b.Name='字段名'