List:General Discussion« Previous MessageNext Message »
From:Rhino Date:May 2 2005 9:09pm
Subject:Re: table that keeps info on tables in a DB
View as plain text  
----- Original Message ----- 
From: "V. Agarwal" <vka3@stripped>
To: <mysql@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.

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

Thread
table that keeps info on tables in a DBV. Agarwal2 May
  • Re: table that keeps info on tables in a DBSGreen2 May
  • Re: table that keeps info on tables in a DBPeter Brawley2 May
  • Re: table that keeps info on tables in a DBRhino2 May