If you want to reuse a temp-table handle for a different temp-table definition, you can invoke the CLEAR() method on the handle. The CLEAR() method takes no arguments. It empties the temp-table if there are any records in it and completely erases its definition, returning the handle to the clear state. At this point, you can begin to build up a definition again from scratch. There is no way to undo parts of a dynamic temp-table definition, and there is no way to extend its list of fields and indexes once it has been prepared.