Re: SQL command

[Abhay]

If u'r using SQL Server, use exec('sp_tables') It is stored procedure ... Abhay ----- Original Message ----- From: Anthony Mak <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, January 09, 2001 8:20 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