sql server查询字段在哪个表
select tab.name as tableName,co.name as colName from sys.syscolumns co join sys.tables tab on co.id=tab.object_id where co.name like '字段名%'
select tab.name as tableName,co.name as colName from sys.syscolumns co join sys.tables tab on co.id=tab.object_id where co.name like '字段名%'