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 sc
Hello William
If you are using MySQL version 5.0 and up, you can select from the
TABLE table in the INFORMATION_SCHEMA database. This database
contains information about all of the structures in the MySQL server.
For example, if you are looking for all of the tables in a database
called