SELECT COLUMN_NAME,TABLE_NAME FROM INFORMATION_SCHEMA.columns WHERE COLUMN_NAME='test' test为字段名 转载于:https://www.cnblogs.com/bluewhy/p/5106295.html