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