#author("2018-08-28T02:12:03+00:00","default:kazuma","kazuma") [[MySQL]] *SQL文 [#n5d3061a] select table_name from information_schema.columns where column_name = '確認したいカラム' and table_schema = '対象データベース'; *実行例 [#x30fee75] mysql> select table_name from information_schema.columns where column_name = 'user' and table_schema = 'mysql'; +--------------+ | table_name | +--------------+ | columns_priv | | db | | procs_priv | | proxies_priv | | tables_priv | | user | +--------------+ 6 rows in set (0.00 sec) ~ ~