SQL Server 通过字段名获取表名
SELECT
syscolumns.name,
sysobjects.name
FROM
syscolumns,
sysobjects
WHERE
syscolumns.name = '字段名'
AND syscolumns.id = sysobjects.id;
SQL Server 通过字段名获取表名
SELECT
syscolumns.name,
sysobjects.name
FROM
syscolumns,
sysobjects
WHERE
syscolumns.name = '字段名'
AND syscolumns.id = sysobjects.id;