今回はメールアドレスがありそうなカラムを調べたかったので、likeで検索しました。
column_nameのところに検索したいカラムの名前、table_schemaはDB名です。
SELECT table_name, column_name FROM information_schema.columns WHERE column_name LIKE '%mail%' AND table_schema = 'hoge';
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme