SELECT
table_name,
ordinal_position
FROM INFORMATION_SCHEMA.COLUMNS
WHERE
table_schema = 'DB_NAME' AND
column_name='column_name';
Search for a specific column name in all the tables in MySQL database?
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment