Posts mySQL - Search column name in all tables
Post
Cancel

mySQL - Search column name in all tables

src - https://takeinproject.wordpress.com/2014/04/23/how-to-search-for-a-specific-column-name-in-all-the-tables-in-mysql-workbench/

1
2
3
4
5
6
7
8
SELECT
table_name,
column_name,
data_type,
ordinal_position
FROM INFORMATION_SCHEMA.COLUMNS

WHERE table_schema = 'xxxdbase' AND column_name LIKE '%confirm%'

origin - https://www.pipiscrew.com/?p=16196 mysql-search-column-name-in-all-tables

This post is licensed under CC BY 4.0 by the author.
Contents

Trending Tags