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.
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has
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
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