[导入]根据column name 查找 table name

select * from information_schema.columnswhere column_name like 'rowID'orselect *  from syscolumns as cinner join sysobjects as oon c.id = o.idwhere c.name = 'rowid'and o.type = 'u'
文章来源:http://blog.donews.com/basilwang/archive/2005/08/23/522018.aspx