SqlServer 查找某个字段在哪个表里
SELECT name FROM sysobjects WHERE id IN (SELECT id FROM syscolumns WHERE name = '字段名称') select [name] from [库名].[dbo].sysobjects where id in(select id from [库名].[dbo].syscolumns Where name='字段名')
标签 Select 下的文章
网事随记
SELECT name FROM sysobjects WHERE id IN (SELECT id FROM syscolumns WHERE name = '字段名称') select [name] from [库名].[dbo].sysobjects where id in(select id from [库名].[dbo].syscolumns Where name='字段名')