William Scott wrote:
> Dear Sir,
>
> I have a database with over 80 tables. Is there an easy way to find
> table names that has PERSON_ID field using SELECT query?
>
> Thanks in advance for any help.
>
>
Hi Scott,
if you are using version 5.0 or higher, you can query the schema tables in
the information_schema database:
http://dev.mysql.com/doc/refman/5.0/en/information-schema.html
In case you are using an older version, you need to issue a "show tables"
query, iterate over all the tables, execute a "describe TABLE" statement
for each and parse the output.
Cheers
Frank
