MySQL
keyboard_arrow_down 295 guides
chevron_leftGeneral table Cookbook
check_circle
Mark as learned thumb_up
0
thumb_down
0
chat_bubble_outline
0
Comment auto_stories Bi-column layout
settings
Finding all tables with a specific column name in MySQL
schedule Aug 12, 2023
Last updated local_offer
Tags MySQL
tocTable of Contents
expand_more Master the mathematics behind data science with 100+ top-tier guides
Start your free 7-days trial now!
Start your free 7-days trial now!
It is possible to check for all tables within a database that contain a specific column name using the below:
SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNSWHERE COLUMN_NAME IN ('specific_column1')AND TABLE_SCHEMA='specific_database';
specific_column1 represents the column name you would like to check for.
specific_database represents the database that tables you would like to search for reside in.
Example
To locate all tables containing the column student_id within the people database:
SELECT DISTINCT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNSWHERE COLUMN_NAME IN ('student_id')AND TABLE_SCHEMA='people';
+----------------------+| TABLE_NAME |+----------------------+| copy_drivers_license || drivers_license || extracurricular || new_drivers_license || students || students_copy |+----------------------+
Published by Arthur Yanagisawa
Edited by 0 others
Did you find this page useful?
thumb_up
thumb_down
Comment
Citation
Ask a question or leave a feedback...
thumb_up
0
thumb_down
0
chat_bubble_outline
0
settings
Enjoy our search
Hit / to insta-search docs and recipes!
