Hi,I'm doing a project using jsp, java script, HTML as front end and sql server as backend.i want to create my database inn runtime. while doing so ,1. how do i check for an already existing class2. if there is an already existing class then i need to update the table .how do i do this. can any one guide through this.vidhya

nishant_jaina

 Profile Answers by nishant_jaina 

• Apr 26th, 2006

 

hi vidhya

can u expalin ur question in detail.

vidhya

• May 3rd, 2006

 

my queation is:In my database i have many tables. i need to create those tables in runtime. while doing so how do i check for already existing table? it should not be overwritten . if there is a table already the data what i insert should be updated to that respective table. plz help me soon.its high i should have completed my project. but have not.with regards vidhya

Sita Kiran sankara

• May 21st, 2006

 

Dear Vidya,

              First of all pass a database command " desc <table name> "using executeQuery() function. Depending on the value returned you can determine whether the table exists if it does not then proceed your way .....Hope it works and your problem gets solved.

Bye...

vidhya

• May 21st, 2006

 

thanks, hope this would work.but can u give an example of what kind of value it may return and how to check it.vidhya.