Hi All,

In oracle we can get the columns related information for a particular shcema by quering from user_tab_columns. As a administrator I can write a script file which gives the result of the differences if there are any in a given two schemas.

Is there any way to get the column information other than " SHOW FIELDS FROM tablename" ???

Regards,
Sekhar

Hi Sekhar,
Did you ever find out how to do this, I've been looking for ages.

Steve

http://www.mysql.com/doc/en/SHOW.html

SHOW [OPEN] TABLES [FROM db_name] [LIKE wild]

SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE wild]

Closest that I found...

Kam

Yes but the problem everyone seems to be having is how to do a select on these details.

i.e Select * from (Show Tables) where tablename = 'z'

And then possible do a join on the details for the columns of that table.