How to check if a table exists and replace if it does?

[prholland]

How do you check if a table exists and replace if it does?

I've tried "DROP TABLE x IFD EXISTS":

rs=st.executeQuery("DROP TABLE " & MDB_TABLE & " IF EXISTS")

but I get error messages like:
Message: syntax error, unexpected DROP, expecting BETWEEN or SQL_TOKEN_IN or SQL_TOKEN_LIKE.

................Phil
_________________
--
Philip R Holland
[OOo 1.1.5 + 2.3.1, WinXP Pro/Ubuntu 7.10]
Holland Numerics Ltd, Royston, Herts, UK

[prholland]

I think I've resolved my own problem. The table I was trying to delete was connected using sdbc:dbase:, which, unfortunately, can only be connected as Read Only, so this caused the error message.

.........Phil
_________________
--
Philip R Holland
[OOo 1.1.5 + 2.3.1, WinXP Pro/Ubuntu 7.10]
Holland Numerics Ltd, Royston, Herts, UK

[Danad]

I guess you´ve to:
- get a container with getTables
- call method dropByIndex or dropByName
- append a new table

It seems there is not any API to replace a table.

HTH

[prholland]

When I converted the table the HSQLDB, the code I used worked fine, as the connection was now Read/Write. The performance of the data load, however, was not acceptable when adding 200K records, so I've reverted to just reading an existing CSV file instead.

.........Phil
_________________
--
Philip R Holland
[OOo 1.1.5 + 2.3.1, WinXP Pro/Ubuntu 7.10]
Holland Numerics Ltd, Royston, Herts, UK

[Danad]

Well, HSQL works with TEXT TABLES maybe it is good to you, more info:

http://www.hsqldb.org/web/hsqlDocsFrame.html

Chapter 6 - Text Tables

HTH