List all tables containing a given column name
How do a I list all tables containing a given column name? I'm using Mysql version 4.1.13-nt-log. I kno开发者_开发百科w versions less than 5 dont have an information_scheme DB.
Find all tables and columns where column names are like the search term:
SELECT DISTINCT TABLE_NAME, COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE COLUMN_NAME LIKE '%partial_column_name%'
AND TABLE_SCHEMA='YourDatabase';
try this:
mysqldump -u root -p –all-databases –single-transaction > all.sql
and then do the searching the old-school way in a text editor with find
also found this... looks promising, but I'm not sure how ambitious you are
http://mike.kruckenberg.com/presentations/Creating_INFORMATION_SCHEMA.pdf
Much more easily
SELECT DISTINCT TABLE_NAME FROM your_schema.columns WHERE column_name = 'your_column_name';
select table_name,column_name,data_type,data_length
from user_tab_columns
where column_name LIKE 'WHATEVER_U_WANT'
;
精彩评论