CHECK IF A TABLE ALREADY EXISTS

i have been able to create a table in a database using java. now i want to check if a specific table exists in that database and if that table exists, then just insert values in it or else create a new table. PLEASE HELP ME OUT!!!
Thanks in advance for any help

Look at Connection.getMetaData().

you can do with using the getTables method of DatabaseMetaData Interface. See the complete signature of this method on Java Doc

You could do "SELECT 1 FROM [TABLE_NAME]" although then you'd have to do exception trapping which should be avoided if the table not existing is a common event.

Thanks to you all. It works. Now i want to get all the tables in the database or just count the number of tables exists in my database. How do i do it. Iv got a code and when i execute it, i get an error saying that the feature is not present in my ACCESS DATABSE. Please help me out for new codes or for the prob. Thanks

could i get also the data or the row count for each table found in the database

The query SELECT TNAME, ROWNUM FROM TAB WHERE TABTYPE = 'TABLE' can be used to get the table name and the row number of that tablename.

Hope this may help you.

it didnt work. Actually can i get some more information about what to replace in the select query. i have a database name "DATABASE", and i have 2 tables named "TABLE1" and "TABLE2". i am using MICROSOFT ACCESS DATABASE and JAVA to get all the tables in the database and the data inside each table. please help me out!!!