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.
if you are using version 5.0 or higher, you can query the schema tables in
the information_schema database:
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.