Actually within the loop I am creating a view lv_Head_Claim from 3 tables. After creating the view I am copying the data to a new table whose name I donot know but the name of the new table is same as the value in the variable called VarBatch_num, which actually is the value from the Batch_num field of the view.Lets say the varBatch_num has the value "AC072", this should be the name of the new table in which i will insert the data from the view. So I wrote the command

copy to (varBatch_num)
that creates the table "AC072" and copies the data too. Loop now puts different value in varBatch_num and again the new table is created say "AC073" etc.. This works fine.
Sometimes if a table of name say "AC072" already exist, I get the message "f:\pinnapp\Ac072 already exist. Do you want to overwrite it" ( earlier it gave me the message "File in use..). In this scenerio I donot want the user to see this message box rather the existing table should be deleted so that copy command could create the new table with same name without giving user any message. Inserting data in existing data won't work as the structure of already existing table can be different.

thanks
bharat