根据字段名查找所有表

SELECT sysobjects.name
FROM syscolumns INNER JOIN
sysobjects ON syscolumns.id = sysobjects.id
WHERE (syscolumns.name = 'here is the feildname')[@more@]SELECT sysobjects.name
FROM syscolumns INNER JOIN
sysobjects ON syscolumns.id = sysobjects.id
WHERE (syscolumns.name = 'here is the feildname')

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/310974/viewspace-1016167/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/310974/viewspace-1016167/