----- Original Message -----
From: "V. Agarwal" <vka3@stripped>
Sent: Monday, May 02, 2005 2:26 PM
Subject: table that keeps info on tables in a DB
> which sytem table is checked when 'show tables'
> command is executed in MYSQL ?
If you want to get information about your tables and your database, there is
one way to do it that doesn't involve upgrading to Version 5.0 or using the
Show commands: you can write a Java program that interrogates the java.sql
classes, particularly DatabaseMetaData and ResultSetMetaData.
I have done this succesfully in Version 4.0 on several occasions.
Of course, if you don't know Java or don't want to write a program to find
out about your databases, this will not be an attractive option for you.
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 29/04/2005