How check if table exist in MS Access using SQL Standard or Java ?
Hi!
I check if table exist and then create table if it is not exist using standard sql:
SQL:
create table if not exists table_name (name char(20), occupation char(20))
OK, it's work on MySQL, but on MS Access it NOT work!.
I need to write SQL query (or java code) that work on all databases (MS SQL, MS Access, MySQL, Oracle, SQLite and so on).
How?