List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:August 22 2006 7:18pm
Subject:Re: Finding field in all tables
View as plain text  
>Is there any way to find a column name (or, better yet, 
>a partial column name) in all tables within a data base?

1. If the db is not in 5.0, mysqldump the DML to a file, run that file 
in an instance of MySQL 5.x.
2. Query information_schema.

PB

-----

Jerry Schwartz wrote:
> Is there any way to find a column name (or, better yet, a partial column
> name) in all tables within a data base?
>
> I inherited a complex and totally undocumented data base, and need to find
> out (for example) which tables have a column name like xxx_exported.
>
>
> Regards,
>
> Jerry Schwartz
> Global Information Incorporated
> 195 Farmington Ave.
> Farmington, CT 06032
>
> 860.674.8796 / FAX: 860.674.8341
>
>
>
>
>   


-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.11.5/425 - Release Date: 8/22/2006

Thread
Finding field in all tablesJerry Schwartz22 Aug
  • RE: Finding field in all tablesGeorge Law22 Aug
    • RE: Finding field in all tablesJerry Schwartz22 Aug
  • Re: Finding field in all tablesPeter Brawley22 Aug
    • RE: Finding field in all tablesJerry Schwartz22 Aug
      • Re: Finding field in all tablesPeter Brawley22 Aug
        • RE: Finding field in all tablesJerry Schwartz22 Aug
          • Re: Finding field in all tablesPeter Brawley22 Aug