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.
Hi Friends, i would like to know how to check if a particular table name exists in a database (in the java program). When i give a create statement , if the table already exists it throws an exception. I tried dropping the table first and then creating a new..that too gives a problem in cases where the table doesnt exist..can someone help me out thanks maggisesh
Hi, You can execute this query before creating or dropping the table. Based on the returned value, either create or drop the table. select tname from tab where tname ='XYZ'; if the result set contains rows then the table exists else table does not exists.