整个数据库查找 placement 字段：
select * from INFORMATION_SCHEMA.columns where COLUMN_NAME Like ‘%placement%‘;
根据 Database 数据库 查看 ColumnA,ColumnB字段：
SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE COLUMN_NAME IN (‘ColumnA‘，‘ColumnB‘) AND TABLE_SCHEMA=‘Database‘;
原文：http://www.cnblogs.com/-mrl/p/5508294.html