Temporary table into existing table

[#1]

In my script I first load a table using:

[Table_A]:

Load

   field1,

   field2,

   ...

   fieldN

from [Path_to_my_excel];

Later I have create a temporary table, let's say, TEMP_TABLE, from [Table_A] and then join TEMP_TABLE with another table.

The result joining table, TEMP_TABLE, has the same columns as [Table_A] but now what I want is to copy entire temporary table TEMP_TABLE into [Table_A], but not append to it, I mean, I want to remove all the records from [Table_A] and copy to [Table_A] the new records from temporary table TEMP_TABLE.

So how to copy all the records from TEMP_TABLE into [Table_A] (not keeping existing [Table_A] records)?

[afurtado · Accepted solution]

Tony,

drop table Table_A;

RENAME TEMP_TABLE to Table_A;

[sunny_talwar]

How about Dropping Table_A and renaming TEMP_TABLE to Table_A whenever you have the TEMP_TABLE ready to be called Table_A

[Table_A]:

Load

  field1,

  field2,

  ...

  fieldN

from [Path_to_my_excel];

.

.

.

DROP Table Table_A;

RENAME Table TEMP_TABLE to Table_A;