[导入]根据column name 查找 table name
2006-05-25 23:23 BAsil 阅读(81) 评论(0) 编辑 收藏 举报
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
文章来源:http://blog.donews.com/basilwang/archive/2005/08/23/522018.aspx