Seong Y. Kim wrote:
> Hi, all
>
> Does anyone of you know how to check if a certain data table exists?
> I need to know if the data table that I want to create exists. If not, I need
> to create one.
>
The simplest way would be to try to select something from the table, using a WHERE
clause that you know won't retrieve any data. If the table is there, your code
will execute normally (but not return any results). If the table is not there,
you will get an SQLException.
Craig McClanahan
___________________________________________________________________________
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
