Scan all tables nfor some variables
 

hi all,

Is there a code where i can check from all the existing tables if a certain variables exist in it? I am currently working on a project but the tables are not linked properly, having a hard time trying to find out how many tables actually have the same variable as the key table.

Thanx

Re: Scan all tables nfor some variables
 

What do you mean when you say you want to find out "how many tables actually have the same variable as the key table?"

Re: Scan all tables nfor some variables
 

Hi again,

you need to query the system tables (dictionary/catalogue) of MySql. Start with columns table.

krs,
tesu