列名を検索する

SELECT c.Table_Schema, c.Table_name, c.Column_name
FROM INFORMATION_SCHEMA.COLUMNS c
INNER JOIN INFORMATION_SCHEMA.TABLES t
ON c.Table_schema = t.Table_SCHEMA
AND c.Table_name = t.Table_name
WHERE TABLE_TYPE = 'BASE TABLE' AND c.Column_name = ''