the command is

    select * from tab;

Living on earth may be costly,but it includes a free annual trip around
the sun.

Divakar D Laad.
Software engineer.
PSI Data Systems Limited.
3rd Floor,Shankaranarayana Building-1.
No.25,M.G.Road,Bangalore-560 001.India
Tel : (91-80)532-1829/39  Fax : (91-80)532-1817
e-mail: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
Web site  http://www.psi.soft.net



-----Original Message-----
From: A mailing list about Java Server Pages specification and reference
[mailto:[EMAIL PROTECTED]]On Behalf Of Anthony Mak
Sent: Tuesday, January 09, 2001 8:20 AM
To: [EMAIL PROTECTED]
Subject: SQL command


Sorry this is not an servlet/jsp question.

Can anyone tell me the SQL statement to show all the table definition in a
database? I want to see what tables are there and their fields name and
types.

Anthony Mak

===========================================================================
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

===========================================================================
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

Reply via email to