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.