根據欄位名查詢所有表

gavinlee發表於2009-01-16
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章