USE Information_schema;
SELECT TABLE_NAME FROM COLUMNS WHERE COLUMN_NAME='字段名称';
SQL Server语句
select a.name as TableName,b.name as ColumnsName
from sysobjects a, syscolumns b where b.name='rankid' and a.id=b.id
b.name=字段名
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024