Re: How can i get all table's name from JDBC driver?

[BENARD Christophe, DDE 34/SG]

What type of databases are you working with ? Oracle, DB2, MySQL ???
If you are working with Oracle, you can use this kind of statement :
SELECT COLUMN_NAME, TABLE_NAME
FROM COLS
WHERE TABLE_NAME IN
(SELECT TABLE_NAME
FROM ALL_TABLES
WHERE OWNER LIKE 'YOUR_SCHEMA_NAME')
ORDER BY TABLE_NAME, COLUMN_NAME;

HTH.
Bye.

Chris

 

-----Message d'origine-----
De: Jo�o Folha [mailto:[EMAIL PROTECTED]]
Date: vendredi 27 juillet 2001 04:26
�: [EMAIL PROTECTED]
Objet: Fw: How can i get all table's name from JDBC driver?


 
----- Original Message ----- 
From: Jo�o  <mailto:[EMAIL PROTECTED]> Folha 
To: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>  
Sent: Tuesday, July 24, 2001 3:48 AM
Subject: How can i get all table's name from JDBC driver?

Hi there,
 
I need to get all table's name from JDBC driver and all column's name from
any table.
 
Can you help me?
 
cheers
Jo�o Folha

==========================================================================To 
unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:

 http://java.sun.com/products/jsp/faq.html
 http://www.esperanto.org.nz/jsp/jspfaq.html
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
 http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets