This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
I use Bosun's suggestion number 2: create the table, if an exception is thrown, I assume that it already exists so I truncate it ( delete all rows ) to make sure I'm starting with an empty table. Jamie
Originally posted by Sanjay Jadhav: Hi.. Yes it's work with DatabaseMetaData, using the exception way is somewhat missleading. with best regards, Sanjay
Caution with this method: relying on every user to have the same odbc drivers is even more missleading. Many ODBC drivers (especially with access) come up short when it comes to DatabaseMetaData ( not implemented ), but you can always guarantee that DML/DDL will work with every version. Unless every user has the same access driver, and you can guarantee that the DatabaseMetaData method is implemented, stick with the exception catching Jamie