AKhan,
Could you not use
REMOVE TABLE TableName | ? [DELETE] [RECYCLE]
before you recreate the table
>hello all
>
>how to add the result of a query into a database where in the table already exist in the database.
>
>eg select * from temp into table catalog database mydbc gives a error message
>
>catalog.dbf already exists as part of a database.
>
>txs
Caroline