查询pwd字段在哪个数据库哪个表

SELECT
	TABLE_SCHEMA,
	TABLE_NAME
FROM
	information_schema.`COLUMNS`
WHERE
	COLUMN_NAME = 'pwd'

查询pwd字段在ERP数据库的哪个表

	SELECT
		TABLE_SCHEMA,
		TABLE_NAME
	FROM
		information_schema.`COLUMNS`
	WHERE
		COLUMN_NAME = 'pwd'
	AND TABLE_SCHEMA = 'ERP'