Re: SQL command

[kenny]

to show tables select * from system.tab; to show table fields desc <table name> kenny -----Original Message----- From: Anthony Mak <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, January 09, 2001 11:08 AM 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, send email to [EMAIL PROTECTED] and include in the body >of the message "signoff SERVLET-INTEREST". > >Archives: http://archives.java.sun.com/archives/servlet-interest.html >Resources: http://java.sun.com/products/servlet/external-resources.html >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html