drop table if exists?

[bplus]

Hi,
I have a java app connected to a MS access database. I need to run an sql command like
"drop table if exists"

You know, so it only tries to delete the table if its actually there. Im not sure how to do this with an access db.

Also what is the difference between delete and drop.

thanks v much for any help!

 

[grnzbra]

Don't know if you have an If Exists function available (judging from the lack of response, I assume that no one knows of any), what you might try is running the command against a table that you know does not exist and find out what error number/message you get. Then write an error routine to continue if that error occurs in this location.