----- Original Message ----- From: "V. Agarwal" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> 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. Rhino -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
