To Nha Notes | June 22, 2022, 11:28 a.m.
USE DATABASE <DB_NAME>;
SELECT
T.TABLE_SCHEMA, T.TABLE_NAME
FROM
INFORMATION_SCHEMA.TABLES T
INNER JOIN
INFORMATION_SCHEMA.COLUMNS C
ON
C.TABLE_SCHEMA = T.TABLE_SCHEMA
AND C.TABLE_NAME = T.TABLE_NAME
WHERE
T.TABLE_TYPE = 'BASE TABLE'
AND COLUMN_NAME = '<COLUMN_NAME>'
ORDER BY
T.TABLE_SCHEMA
, T.TABLE_NAME
;